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 :)

Hi Kathryn,

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