Transpose several columns to one long column
I have 999 columns in a worksheet, each with 8 rows. The data in the first
column, A1-A8 are data points 1-8. Then, the data in column B1-B8 are data
points 9-16..etc. I can't find a command to transpose all 999x8rows of data
into one extremely long column with the data points in the order they were
taken, 1, 2, 3, ...998, 999. Any insight?
|