1. This Board Rocks has been moved to a new domain: CarolinaPanthersForum.com

    All member accounts remain the same.

    Most of the content is here, as well. Except that the Preps Forum has been split off to its own board at: http://www.prepsforum.com

    Welcome to the new Carolina Panthers Forum!

    Dismiss Notice

MS excel question

Discussion in 'Technology Forum' started by token, Jan 20, 2008.

  1. Jan 20, 2008 at 7:56 PM #1
    token

    token I'm a lady

    Age:
    49
    Posts:
    7,473
    Likes Received:
    1
    Joined:
    Jun 26, 2007
    Location:
    North Carolina
    I have columns that I want to be rows and rows that I want to be columns. Is it possible to transpose the data without having to retype?

    Right now:

    Name
    Company
    Address1
    Address2
    City
    State
    Zip

    I want:

    Name - Company - Address1 - Address2 - City - State - Zip.


    Is there a function that can do this? Thanks in advance.

    :detonate:
     
  2. Jan 21, 2008 at 12:06 AM #2
    vpkozel

    vpkozel Professional Calvinballer

    Age:
    57
    Posts:
    35,060
    Likes Received:
    1
    Joined:
    Jan 7, 2003
    Copy the selection then select

    Edit --> Paste Special

    Then select values and select transpose.
     
  3. Jan 21, 2008 at 9:32 AM #3
    token

    token I'm a lady

    Age:
    49
    Posts:
    7,473
    Likes Received:
    1
    Joined:
    Jun 26, 2007
    Location:
    North Carolina
    Thanks. I owe you my next born cat.
     

Share This Page