Deleting Blank Sheet Rows
When you import or download data, you frequently end up with a lot of blank rows that are interspersed among the data. You could sort and then delete all the blank rows or you could filter all the non-blanks but, in addition to being time-consuming, sometimes it does not display the data the way you want.
If you select the column that you are interested in and then click on Find & Select and then select Go To Special .. and then select Blanks - you will find that this is a more efficient way. Then select the dropdown arrow beside Delete on the Cell tab and select Delete Sheet Rows. To see an example of how this works please click here.