Ask Experts Questions for FREE Help !
Ask
    DrJ's Avatar
    DrJ Posts: 1,328, Reputation: 339
    Ultra Member
    		  
    #1

    Jun 18, 2009, 08:55 AM
    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?
    DrJ's Avatar
    DrJ Posts: 1,328, Reputation: 339
    Ultra Member
    		  
    #2

    Jun 18, 2009, 09:43 AM

    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!
    Justwantfair's Avatar
    Justwantfair Posts: 3,422, Reputation: 944
    Ultra Member
    		  
    #3

    Jun 18, 2009, 09:51 AM
    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?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Jun 18, 2009, 03:00 PM
    Quote Originally Posted by Justwantfair View Post
    I am waiting on another question though?
    What question is that?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

Excel: extract surname from column with first name and sometimes initials [ 1 Answers ]

In an Excel spreadsheet I have a column containing first name, sometimes an initial (or two), then a surname then in brackets a date of birth. How can I extract the surname? e.g. one row might be John A Smith (01/01/1990) The next might be John A Smith (02/02/1991) and the next John Smith...

How can I sort data on a Hidden column in Excel? [ 2 Answers ]

I have a spreadsheet that has a pivot table in it. Each record has a time group column and a time nbr column in the pivot table. (i.e. Timegroup = 90 days before and a timenbr of 1 is assigned to this group, Timegroup = 60 days before and a timenbr of 2 is assigned to this group,...

Excel 07 - Pressing enter won't bring me to the A column [ 4 Answers ]

I'm new to excel and learning it at my local college but am stuck with a small problem. say I enter info in A2, then B2... and so on until I get to say... E2. If I hit enter after inputting info into E2 my next active cell is random. its going between all the letters in the next row down,...

Column Protect in excel [ 1 Answers ]

How to protect the column in excel??

View more questions Search