We have a large 5-column table that contains many blank-rows scattered through the list.

We want to condense the table to a new table (on the same worksheet) with no blank rows. Each row that has data has it in all 5 columns. The first column is a date.

So we'd like the new table to be A1:E1250 while the old table moves over to G1:K1675.

Thank you for the help!