help with copying data from many columns into one long column

K

Kathryn39

Hello,

I have a couple of hundred columns of data with about 100 values in eac
column. I'm trying to combine all these columns to make it one lon
column of values; As in I'm trying to get the contents of column B an
place it under the contents of column A, and then the contents of colum
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 an
pasting each column separately as I keep making mistakes that way..:(

All help much appreciated!!

thank you!!
Kathryn :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with finding result from data 0
trying to get data from rows to columns 4
Merge excel files with different column headings 1
matching columns 4
multiple columns into one column and autofill(?) question 1
Newbie needing help with nested VLOOKUP IF function.... 1
Combining data from 2 cells into 1 cell 2
Macro that sorts data with blanks at the bottom 1

Top