Excel 97 Empty Row Challenge

I am importing a report from a legacy system into an Excel 97 spreadsheet. When the import is done I have blank or empty rows between each set of data. Is there a way to run a script or macro or something else I can do to delete the empty rows in one easy step?