If the empty fields among the data in the columns is small to a about 10 numbers then its easy to do manually, but what if its in the thousands. Here is a quick and easy way.
- Select your data
- Press F5
This opens “Go to” dialog in Excel. Now hit on that “select” button.
- From “select special” screen, select “Blanks” (shown aside)
Now, all the blank cells will be selected.
- Just press CTRL and Minus sign (-)
- Select “shift cells up” or “entire row” as needed.
Remember given the amount of data and the size of the file Excel is going to take some time to delete.