On 29 Mar, 13:55, "MartinW" wrote:
Hi,

Try this

Place this in B1
=INDEX(A:A,ROWS($1:1)*2-1)
Place this in C1
=INDEX(A:A,ROWS($1:1)*2)

Highlight both cells and drag down as far as you need.

HTH
Martin

Thanks for reply but I don't think this will solve it....

In my example I had 1000, 1001, 1002 etc. but further down this can
shift to 2005, 2010, 2027 etc
This is just numbers that are inserted as text and are not linear.

Maybe I should put an exampe with A, B, 1, 2, 3, C, H where I want A-
column to have A, 1, 3, H and the other ones in B coloumn