Looking for the best way to condense table with blanks

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!

Alan, thank you for your solution. We're NEWBIE's at Excel, so code is a stretch for us, but we're going to try to make it work.

Thank you for your help! Very much appreciated!