combining two rows of data into one (Not Concatenate)

[Dr Gonzo]

Hello,

I tried to search and couldn't come up with anything so here goes...

For example: I have two columns of data A1:A20, and B1:B20.

I would like to copy them to one column simliar to shuffling cards together
so I have C1:C40 in alternating values A1,B1,A2,B2,A3,B3.... I have tried to
simply start a column like that and copy down but it starts jumping by rows
(A1,B1,A2,B2 and then I start to drag down and it continues with
A5,B5,A6,B6,A9,B9).

Any help is appreciated.

 

[Bernie Deitrick]

Dr.,

Use this formula in C1

=INDEX($A$1:$B$20,INT((ROW()-1)/2)+1,MOD(ROW()+1,2)+1)

and copy down to C2:C40.

HTH,
Bernie
MS Excel MVP