Combine data from multiple rows into a single row

[Mccone]

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?

[#2]

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