How do I transpose horizontal data into vertical data?

Posted on 2011-04-19
Last Modified: 2012-05-11
Good morning, Experts.  

How do I transpose horizontal data into vertical data in Excel 2010?

Basically I want to flip the data 90 degrees so that all of the rows are columns.  I have attached my spreadsheet to this posting.

It sounds simple enough, but I am a little new to Excel.

Joseph JRA-Dashboard2.xlsx
Question by:Ruomra
    LVL 33

    Assisted Solution

    Select the range that you want to transpose and right click and select Copy. Then click on the cell where you want to transpose the data and right click and select Paste Special and select Tanspose.

    LVL 81

    Assisted Solution

    by:zorvek (Kevin Jones)
    Use the TRANSPOSE function. See attached.

    LVL 33

    Accepted Solution


    Author Closing Comment

    That was really simple!  Thank you for such a prompt repsonse.  I especially appreciate the screen shot!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now