| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining rows with similar data | Excel Discussion (Misc queries) | |||
| Combining two formulas using concatenate | Excel Worksheet Functions | |||
| Combining rows of like data? | Excel Worksheet Functions | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| Combining rows of data that have one cell in common | Excel Discussion (Misc queries) | |||
Threaded Mode
