Title pretty much explains it.

If i have 30 rows and 14 of the 30 have values (16 blank rows) i want a script that hides the blank rows.

Any ideas?