Ron wrote:
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

Let A2:A100 house the list of interest with a label in A2.

In B1 enter: 0

In B3 enter & copy down:

=IF(A3<"",LOOKUP(9.99999999999999E+307,$B$1:B2)+1 ,"")

In C1 enter:

=LOOKUP(9.99999999999999E+307,B:B)

In C3 enter & copy down:

=IF(ROW()-ROW(C$3)+1<=$C$1,LOOKUP(ROW()-ROW(C$3)+1,B:B,A:A),"")

The range in C will house a new list with no interspersed blanks.