Use DataFilter. Select Blanks. Now only blank rows will be displayed.
Select these rows, right-click on any row, select Delete Row.

Regards,
Fred.

"swell estimator" wrote in
message ...
I have a large amount of data that is composed of a text row followed by 2
blank rows. This pattern repeats itself in the entire worksheet.

I want to gang remove the blank rows so that I end up with single spaced
data.

Any help out there. Thank you.