Getting rid of blank rows withouth deleting them

[samsg]

Hi, i have a list that looks like this

22

43
22

41
...

I need the list to be together

22
43
22
41
...

However i can't use a macro or something to delete the entire ro
because other worksheets are related to the cells, so when i delte th
row, the #ref thing apears, somebody know a formula or something tha
can help me? Thanks a lo

 

[Debra Dalgleish]

You could filter to hide the blank rows. There are instructions for
AutoFilter in Excel's Help, or here:

http://www.contextures.com/xlautofilter01.html

Select the entire list, then apply the AutoFilter. From the dropdown
list in the heading, choose NonBlanks