View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr Gonzo Dr Gonzo is offline
external usenet poster
 
Posts: 1
Default combining two rows of data into one (Not Concatenate)

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.