Converting two columns into alternating rows

[jtsargent25]

Hello! Is there any way to quickly convert two columns into alternating rows?

old	new
old1	new1
old2	new2
old3	new3

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

into

old1

new1

old2

new2

old3

new3 TIA!

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[steve the fish]

Heres a possibility. Place the formula into a cell that has an even row number such as A6.

=INDEX($A$2:$B$4,INT(ROWS($A$1:A2)/2),MOD(ROW(),2)+1)

 

[steve the fish]

Actually this wont care where its placed:

=INDEX($A$2:$B$4,INT(ROWS($A$1:A2)/2),MOD(ROWS($A$1:A2),2)+1)

 

[jtsargent25]

Thanks, Steve. This is really helpful. I am realizing that I will want the alternating rows to be in a different worksheet (say sheet 2). Would it be possible for you to modify this to that effect? Also - what changes would I need to make to it so that it works for more then three rows. I really appreciate your help.

 

[jtsargent25]

Hey- I figured out how to get it to do more than three rows....but am still stuck on figuring out how to do it across sheets...