I don't have access to XP at the moment but I think it is a "feature".
As a workaround, select the rows and Data/Sort. That will eliminate the blanks (well, move the blank rows to the bottom).
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?