Method for deleting blank rows

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

Use Auto filter to select blanks, then select all the visible rows, then delete, then remove the filter.

Hope this helps.

Pete

.

Please Login or Register  to view this content.

[SOLVED]

Many thanks

.
You are welcome.