converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

convert rows to columns, or columns to rows

Tuesday October 6, 2015 at 10:00am

Say you have column headings:

Pink            Blue                Green

that you want to change into row headings:
Pink
Blue
Green

Moving the data manually, one item at a time, would be a tedious process. To save time, you can use the Paste Special command to quickly transpose a column of data to a row of data, or vice versa.

To transpose rows and columns:           
               
Copy the data in one or more columns or rows.      
            
Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special. (or you can use the Edit menu to find Paste Special)                
         
In the Paste Special dialog box, select Transpose, and then click OK(You'll find the Transpose check box in the lower-right corner of the dialog box)
» Categories: Microsoft Excel

Comments

There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
  
Email Address (kept hidden)
  
Website
 
Comment
  

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 20 - 5?
  
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd