Shifting up rows to eliminate blank rows in real time on second printable sheet

I have a form that I fill out all the time, where a few basic numbers are taken, some calculations are made, and results are spit out onto another worksheet which is formatted for printing.

My problem is often I don't need certain rows so I'm left with awkward gaps in the spreadsheet that have to be manually deleted before I print. It's not a big deal but something I have to do all the time.

Is there a way (formula or VBA, I would prefer formula but I took programming back in college so I know the basics though I've never done VBA) which I can shift up rows so that when I print only the filled rows are shown without a gap in between them (leaving more blank space on the bottom of the page). This ideally needs to be done in real time so that I can click over to my printable sheet and ctrl+p without having to adjust any spacing

Essentially I'm taking several inputs, automatically generating a sheet which has several blanks, then outputting it to a pretty printable worksheet which won't have any blank rows, but will still have the bottom rows in the same place.


BEFORE:

Data 1	123
BLANK	BLANK
Data	12
BLANK	BLANK
Data	12

AFTER:

Data 1	123
Data	12
Data	12