I frequently import large data files in which data overflows the column
creating blank lines plus there are also blank/incomplete data records.
Deleteing the blanks involves turning on autofilter, selection that column,
scrolling to the bottom of data in the list box to the "blanks" and selecting
it. then selecting all the row numbers that is lists, deleting the rows, then
hitting show all data again.