View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sofast1651 sofast1651 is offline
external usenet poster
 
Posts: 3
Default 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?