Forum Discussion
Combine data from multiple rows into a single row
Is there a way to take a single column that is made of 500 rows and have it wrap to 25 columns of 20 rows?
Would you like rows 1-20 of the old data to be in column 1 of the new data, rows 21-40 to be in column 2, rows 41-60 to be in column 3, etc...?
If so, then do the following:
Assuming all of your data is in the range A1:A500, put this formula in cell C1:
=INDEX($A$1:$A$500,ROW(C1)+(20*(COLUMNS($C$1:C$1)-1)))
and copy all the way to cell AA20.
Hope this helps!
PReagan