Friends,

I have a column of data that is thousands of rows long. Intermittently
throughout the data, there are blank cells which I would like to remove
without having to scroll down through the spreadsheet and delete the rows
individually. For example, in the below data, the numbers represent the row
and the word "Data" represents characters within the cells. Notice that in
rows "3" and "5" the cells are blank. Is there a fast way of doing this?

INITIAL WHAT I WANT
1 Data1 1 Data1
2 Data2 2 Data2
3 3 Data3
4 Data3 4 Data4
5
6 Data4