Converting rows to columns in Excel

Discussion in 'Mac Basics and Help' started by jent, Apr 3, 2012.

  1. macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #1
    I am copying and pasting information about some conferences from a large list of panels. When I find conferences that I am interested in, I copy and paste them into a big Word document, but I figure I can compare them more easily in an Excel spreadsheet.

    Each entry is five lines. Here's a sample entry:
    Code:
    Session ID:     1234
    Track Code:     ABC
    Session Name:   How to Change the World
    Day:            Thursday
    Time:           12:30 pm - 2:15 pm
    What I'd like to do is convert the items in the first column into the top row of an Excel spreadsheet. This way, I can look at one single column for a list of dozens of session names and look down a single column to see what times they take place.

    Is there an easy way to do this in Excel when the data I'm getting in the first place is in the above format? Many thanks!
     
  2. macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    1. Select the entire range.
    2. Command-C to copy
    3. Click on a cell outside the copied range as your destination.
    4. Right-click and select "Paste Special"
    5. Check the "Transpose" box and click OK.
     
  3. thread starter macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #3
    Thank you, GGJstudios! It worked like a charm.
     
  4. macrumors 68030

    Joined:
    Sep 21, 2011
    #4
    A small addition to the answer: the keyboard shortcut for paste special is ctrl+cmd+V
     
  5. macrumors newbie

    Joined:
    Jan 21, 2012
    Location:
    Northbrook IL
    #5
    After using ctrl+cmd+v then use cmd+e to select "Transpose", then enter/return to make it happen.

    I'd like to add transpose to the tool bar but I can't find "transpose" in any add to tool bar list. It's not under paste special transpose or under transpose.

    I guess I'll have to make a macro for it.
     

Share This Page