View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily Emily is offline
external usenet poster
 
Posts: 40
Default EXCEL 2000 SINGLE COLUMN OF NUMBERS BREAK INTO MANY COLUMNS

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.