combining two rows of data into one (Not Concatenate)

D

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top