View Single Post
  #1   Report Post  
Kathryn39 Kathryn39 is offline
Junior Member
 
Posts: 5
Default 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 :)