Two options; each makes an assumption

Option 1: Assuming there is some semblance of order to the data; simply
sort the data.............blanks will shift to the bottom.

Option 2: Assuming one column of data always has data and as such the cell
in that column is blank is ONLY the blank row........... consider use of the
"Filter" options of EXCELand do the following:

Turn on Filtering by selecting from the Task Bar Data, Filters, Autofilters

This will activate what appears as a dropdown in each of the column header
cells (Row 1)

In the column identified above that contains data in all but the blank rows;
select the "Blanks" from the bottom of the dropdown displayed

Hit enter

Only the "blank" rows will be displayed

Highlight/select the "blank" rows

Hit "delete"

Then go to the header row and reselect the dropdown from row 1 of the column
and select ALL

Hit enter

Your data now appears without the blanks (they are gone).

"Reeni" wrote:

The problem is there is a blank
rows between blocks of data (37 blocks of data) I want to be able to delete
the blank rows... the blank rows can vary each month...

thanks
--
Reeni