Emily, have a look here for a way to do it

http://www.mvps.org/dmcritchie/excel/snakecol.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Emily" wrote in message
...
Is it possible to take a single column (12,000+ rows)of data and break it
into several columns to be able to print on 8.5x11 paper?

Example:
This: Converted to this across the
page:
123 123 111
456 456 222
789 789 333
111
222
333


I know about transpose but it gives the data across the page instead of
the
direction noted above.