Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Houston, Texas, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Back with Works 3.0 there was a Report Wizard that easily took my single column of data and created a multiple column print format. Never found how to do this in excel. I need to print a single column into a multiple column printout in order to get all data on one sheet. Any suggestions? I am using Excel 2007 and Word 2007 only. There's gotta be a simple answer.

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    If you want to turn multiple rows of data into mutiple columns of data or visa versa.

    1. Select the data you wish to transpose.
    2. Select Copy
    3. Go to the Cell where you want the data to appear in the worksheet.
    4. Paste Special and when the dialog box appears select "Transpose" then OK

    The Row data is transposed into Columns.

    I hope this is what you needed.

    Regards,

    Tom D

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts
    You can paste the data into Word and use Format | Columns
    or
    try to find a third party utility/add-in to arrange the columns in Excel.
    '--
    Jim Cone
    Portland Oregon USA
    Special Print (Side by Side) add-in

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi,

    Checkout this URL at the ExcelTips website for a macro to do it for you:

    http://excel.tips.net/Pages/T002219_...e_Columns.html

    Good Luck!

    Peter Moran

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •