Snippets home page
 
 
register
 
 
computer

How can I convert columns into row in Excel?

I an Excel tip.

asked by wkintg01 (45)

You have 50 words left!
 
 
related questions

Does anyone know of a macro for transposing row data into columns?

How do I separate a CSV file into multiple Excel columns?

How do you convert a table to an Excel spreadsheet?

How do you perform remedial repair of rotting wood columns?

How do you set auto width's of your columns in excel?

How do you use every seventh row in excel?

What control key do you use in Excel to collapse columns?

Tags:  computer  software

answers

select the cells that you want to convert,click copy,select the upper left cell of the paste area,the paste area must be out side of the copied area, click the arrow to the right of the paste and then click transpose your columns will be convert into rows.

7 votes

Copy your data and paste it by right-clicking and selecting Paste Special. Select "Transpose" and hit OK to paste your data. This only works in Excel 2000 or more recent, however.

5 votes

If you have data in columns and you want to change that into row just select the data and copy then go to the row where you want the info and right click, select paste special and select transpose option and click OK that will change columns into rows

reply
posted by Naimad (98)
4 votes

To transpose from a Column into a Row. To transpose the values in Column A (List1) into a Row: Using the INDEX and COLUMN functions, enter the following formula in cell C2, and then copy it across the next 3 cells in the row.

reply
posted by Rani60 (345)
4 votes

One must, copy the data in the source column first. Then right click in the row, and click paste special. On the paste special dialog box choose, all, none, and transpose.

3 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy