Source data (ie your long col) assumed running in A2 down ...
In say, B2: =OFFSET($A$2,COLUMNS($A:A)*50-51+ROWS($1:1),)
Copy down by 50 rows to B51, fill across as far as required to exhaust.
Continuous zeros will signal completion of data extract from col A. Any good?
hit the YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"SandyDi" wrote:
I want to take one long column (544 rows) and split it into columns of 50.
Is there a way to do that in Excel?