Select the data range...
select Edit..then Go to..specials or (ctrl G, then special)
select Blanks then click Ok...proceed to delete operation

-----Original Message-----
I have a spreadsheet with data in column 1.

every other row is empty, I would like to delete this
rows in order to
compact my data.

Thanks.
.