Copy the list to your other sheet. In this other sheet, select the whole
range from top to bottom. Press the F5 key, click on Special, click on
Blanks, click OK. Click on Edit - Delete - Shift Cells Up. Done
HTH Otto
"girth69" wrote in
message ...

I have a spreadsheet with a set of data in a list in just one coloumn.
this list however has some blanks in it.

What i want to do is on another sheet have a shortened version of this
list to avoid any blank cells appearing. Is there a formula i can use
to do this??

e.g current list :-

1

234

112

123

needed list

1
234
112
123

all i can think to do is select = and then type the reference of the
top cell, drag down until i have all the necessary data and then just
delete the rows where blank values appear. surely theres a way i can
avoid doing this?? please help!


--
girth69
------------------------------------------------------------------------
girth69's Profile:
http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=532316