Deleting Blank Rows

Yes- Everyone knows how to delete a blank row  but what if you have downloaded a lot of data and see that you have sporadic blanks throughout rows and rows of data?  For instance,in the example below, I have 8 Customers but only sales for 3 and and a lot of extra...