Splitting column into alternative numbers

[Guest]

I have a problem;
I have in column A numbers 1 to 10
What i want to do is to split the column so that in alternative numbers
appear in column B & C.

example

Column B Column C
1 2
3 4
5 6
7 8
9 10

Simply saying B1=A1 & C1=A3 does not work as it does not flow down in the
alternative manner.



Thank you in advance
DD

 

[JE McGimpsey]

One way:

B1: =INDEX(A:A,(ROW()-1)*2+1)
C1: =INDEX(A:A,ROW()*2)