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