This video demonstrates two methods for deleting all blank rows in your data.
------------------------