Hi,

Im trying to go through a whole excel worksheet and delete all the blank
(empty) rows and push up the data in between up with other data... is there
any function that does this? Something to make the worksheet compact.

Let me illustrate:

Befo
DSG FAF GSE HSS DGB
DVG F4F G7E H9S 3GB

HDS WEY DHF SGD SGE


GSE SDB CVR H3G HRQ


After:
DSG FAF GSE HSS DGB
DVG F4F G7E H9S 3GB
HDS WEY DHF SGD SGE
GSE SDB CVR H3G HRQ



Thank you