Let column A from A3 on house the sample you provided.

Enter 0 in B2.

In B3 enter & copy down:

=IF(A3<"",LOOKUP(9.99999999999999E+307,$B$2: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),"")

"Dagfinn" wrote in message
...
Hi,

I have one challenge:

I want to pick values from one column and place them succesively and
automaticely in a new one - and ignore every empty cell; f.eks.

In Column A there are values/ text in row 3, 5 ,8 and 12 (all other celles
are empty). These values i want to automatically transferred to Column B
in
row 1, 2, 3 and 4.

What's the formula for doing this??

Regards dagfinn