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:
and copy all the way to cell AA20.
Hope this helps!