[solved]Moving columns

Hello everyone,
I am glad to find this great forum. I am sure I can learn a lot about Excel through this great forum with a lot of experts and professionals!
I'm using Excel 2003
Here is the question.
In short, I want all the data in A3 to B2, A5 to B4, A7 to B6
Original data
A2 Peter
A3 brother
A4 Mary
A5 Mother
A6 Sam
A7 Father

Wanted to be listed as follow

A2 Peter B2 brother
A3 Mary B3 Mother
A4 Sam B4 Father

I'm sure many of you awesome guys know the formula or the trick. My excel skills are really poor... Thank you so much! I really appreciate your help!

See the green cells in the attached file.

e2=INDIRECT("A"&(row()-1)*2) and drag down.

f2=INDIRECT("A"&((row()-1)*2)+1) and drag down.

Thanks for the reply.

Glad I could help.

You can add rep(utation)points to the one who helped you by clicking on the start (on the left side).