How to split every alternate row into 2 separate columns?

[gelin]

There's probably someone who has similar problem as mine and posted it but somehow I cannot find it on the forum so I apologize if I double posted this problem. Anyway, my lab workstation outputs data in a single string when imported into excel places each x and y datum consecutive to each other in a single column like this:

__A
1 x1
2 y1
3 x2
4 y2
5 x3
6 y3
7 x4
8 y4
etc.

I will like to to find a way to arrange the data into 2 columns which reflect the corresponding x to y:

__B__C
1 x1 y1
2 x2 y2
3 x3 y3
4 x4 y4

How can this be done?

[martindwilson]

in b1
=INDEX($A:$A,ROW(A1)*2-1)
in c1
=INDEX($A:$A,ROW(a1)*2)