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).
Hands-on: Acer Predator Triton 700 review
1995-2015: How technology has changed the world in 20 years
This poetic animation about monsters is illustrated in a Van Gogh painterly style
Apple predictions 2017
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.