# Converting two columns into alternating rows

#### jtsargent25

##### New Member
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>

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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)

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)

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.

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...

Replies
1
Views
647
Replies
17
Views
598
Replies
15
Views
1K
Replies
7
Views
1K
Replies
7
Views
1K

1,203,070
Messages
6,053,364
Members
444,657
Latest member
jessejames1of3

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back