One way, assuming you want it dynamic ..

Assume source list is in col A

Put in C1: =IF(TRIM(A1)="","",ROW())

Put in B1:
=IF(ISERROR(SMALL(C:C,ROWS($A$1:A1))),"",INDEX(A:A ,MATCH(SMALL(C:C,ROWS($A$1
:A1)),C:C,0)))

Select B1:C1, fill down to say, C200,
to cover the max expected data range in col A

Col B will return the desired results from col A
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ron" wrote in message
...
I have a list in a column but some values are blank. I would like to make
a
new list in another column but without the blanks.

thx
Ron