| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help with copying data from many columns into one long column
Hello,
I have a couple of hundred columns of data with about 100 values in each column. I'm trying to combine all these columns to make it one long column of values; As in I'm trying to get the contents of column B and place it under the contents of column A, and then the contents of column C and place it under the the combined A and B contents etc.. Just wondering if there is a quick method to this apart from copying and pasting each column separately as I keep making mistakes that way..:( All help much appreciated!! thank you!! Kathryn :) |
|
#2
|
|||
|
|||
|
Quote:
Not easy to give the exact formula without sight of your data, but have a look at the link below. The second formula is the one you'll be interested in. http://www.exceltip.com/st/Transposi...lumn/1092.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying data from 205 columns to 1 column | Excel Worksheet Functions | |||
| Need help copying data from one column to specific columns | Excel Programming | |||
| 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) | |||
| Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
Linear Mode
