How to work with Excel data with blank rows without using a macro.
Select the complete data
Go to the Data Tab
Select Filter from the command group Sort & Filter
Click on one of the drop-down arrows on the header row
Under Text Filters de-select the item (Blanks).
Click OK.
All the blank rows are removed.
Now you can perform actions on the data like AutoFilter.
Watch the training video:
Further reading:
Guidelines for organizing and formatting data on a worksheet