Snippets home page
 
 
register
 
 
computer

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

I need to fix my spreadsheet.

asked by corihendon48 (10)

You have 50 words left!
 
 
related questions

How can I convert columns into row in Excel?

How can I move horizontal data to vertical data in excel?

How do you create a marco that will allow the end user to input data?

How do you crochet the second row?

How do you fix an Excel macro run-time error?

How do you perform remedial repair of rotting wood columns?

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

Tags:  computer  software

answers

There is no macro. Just copy the information, select the cell where you wish to start the column, and then click Edit, Paste Special. When the paste special dialog box opens, there will be an option in the bottom right of the box that says "transpose". Place a check in the box next to the word and you are done.

7 votes

There is no need to use a macro if using Excel. Highlight the cells containing the data and copy them. Move the cursor to where you want to paste the transposed data, and select Paste Special from the Edit menu. Click the checkbox marked Transpose and hit OK.

7 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