Remove blank rows that aren't really blank (contain unused formulas)

Hi all. I have a spreadsheet that contains rows of formulas on sheet 1 that point to sheet 2. The amount of data on sheet 2 varies, so I need a macro to delete a "blank" row, even if it contains an unused formula.

I wan it to delete the unneeded rows and move the rows showing total up below the last line of data. I can make it delete blank rows, but I can't figure it out how to delete the "blank" rows that contain formulas. Attached is a sample of my spreadsheet. So confused right now! Thanks for your time, I'm learning so much.