| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to combine multiple columns into different cells in one column
I have data in different columns starting with column A going down row 1 thru
14. So column B row 1 thru 14, column C 1 thru 14, etc. I need to consolidate everything from column a1-a14 to agu1-agu14 into one column, for example: a1 a2 a3 .. .. .. a14 b1 b2 b3 .. .. .. b14 etc. How do I go about doing this? I tried doing transpose and that didn't work. I'm using Excel 2007 if that makes a difference. Thanks Blake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple columns | Excel Discussion (Misc queries) | |||
| How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| How do I combine multiple columns into just 1 column? | Excel Discussion (Misc queries) | |||
Threaded Mode
