Say your datalist is in A1 to A544.

Enter this formula *anywhere*, and copy across 10 columns (that's 11 columns
*total*),
THEN, copy that 11 column selection down 50 rows:

=INDEX($A$1:$A$544,ROWS($1:1)+50*(COLUMNS($A:A)-1))

If you're looking to eventually delete the *original* datalist, you must
first remove the formulas from the *new* datalist, leaving just the values
behind.

With the new datalist *still* selected from the copy,
right click in the selection and choose "Copy",
right click again and choose "Paste Special",
click on "Values",
then <OK, then <Esc, and you're done.

You now have only data in the new locations, so the original list can now be
removed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"SandyDi" wrote in message
...
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?