Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel - Copying a row to a column (https://www.askmehelpdesk.com/showthread.php?t=366366)

  • Jun 18, 2009, 08:55 AM
    DrJ
    Excel - Copying a row to a column
    I have a list of data in Row 1 that I would like to be displayed down Column A instead. Is there an easy way to transfer it from one to the other?
  • Jun 18, 2009, 09:43 AM
    DrJ

    EUREKA!

    Well, I figured it out in case anyone else is wondering.

    First copy the data in the row (lets say A1 - A100). Then select the top of the column that you want to paste to (lets say B2... you cannot select A1 as it will overlap and cause an error).

    Then under Paste Special (or the Paste drop down for Excel 2007) select Transpose.

    Viola!
  • Jun 18, 2009, 09:51 AM
    Justwantfair
    Kudos, it's always great when you figure out your own questions, before anybody even has a chance to read...

    I am waiting on another question though?
  • Jun 18, 2009, 03:00 PM
    JBeaucaire
    Quote:
    Originally Posted by Justwantfair View Post
    I am waiting on another question though?
    What question is that?

    • All times are GMT -7. The time now is 11:31 AM.