I have a CSV with around 800 rows. The rows are arranged so that there's one row of data, then a blank row, then another row of data, etc. I want to remove all the blank rows.

I've tried using Special > Blanks and then selecting (in the ribbon) Delete > Delete Sheet Rows.

The problem is that Special > Blanks selects blank cells in the rows of data, as well as the empty rows. Therefore when I run the deletion command, this deletes both the empty rows and any row of data which has an empty cell (each row with data contains up to 10 cells of data).

Does anybody knows of a workaround for this? It struck me that I could populate the empty cells in the data rows with dummy data, but I can't see a easy way of doing this in one go.

Thanks