Need a formula to convert to columns to two rows

[Learner326]

Need a formula to convert TWO columns to two rows:

I have two columns like this:

Column A Column B
Apple Red
Mango Green
Banana Yellow

I want a formula to convert it like this:

Column A Column B
Apple
Red
Mango
Green
Banana
Yellow

I mean the text at the second column should come at the row below the corresponding row of at 1st column. And this should go on for 35000 rows.

Any help would be much appreciated! Thank you!

[martindwilson]

one way
=INDEX(A:B,CEILING(ROWS($A$1:A1)/2,1),MOD(ROWS($A$1:A1)-1,2)+1)

[Learner326]

Thanks a MILLION martindwilson! You just made my day! It is working like a charm!


Thank you soooooooooooooooooooo much.......................