If you set up Autofilters then you can filter one column for (blanks),
then highlight all the blank rows which are displayed (row identifier
turns blue) and Edit | Delete Row in one operation. Select (All) from
the filter pull-down list and all your blank rows will have gone.

Hope this helps.

Pete