Dagfinn, try this formula. Paste into cell B1, press F2 then
CTRL+SHIFT+ENTER. Then copy the formula down as far as you want.

=IF(INDEX($A:$A,SMALL(IF($A$1:$A$65535<"",ROW($A$ 1:$A$65535),65536),ROW()+1-ROW(B$1)))=0,"",INDEX($A:$A,SMALL(IF($A$1:$A$65535 <"",ROW($A$1:$A$65535),65536),ROW()+1-ROW(B$1))))

After that, if you want to start the list on another row just edit the 2
instances of ROW(B$1) by changing the absolute row number from 1 to the new
starting row number.

Hope you like it. Merry Christmas!


"Dagfinn" wrote:

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