Wednesday, May 30, 2012

MS Excel Transpose Rows and Columns

Tags:

Convert Row to a Column in Excel

Excel rows to columns

Switch Excel Columns to Rows

MS Excel Change Row into Column

Convert Rows to Columns and Columns to Rows in Excel

How to Convert Rows to Columns in Excel?

How to Convert Columns to Rows in Excel?

Transpose Excel Rows and Columns

MS Excel transpose data from rows to columns OR columns to rows

 

Step 1:

 

Select the table or colums & rows you wish to flip.

 

 

 

 

Step 2:

 

Copy the entire table and click Pate >> Paste Special.

 

 

 

 

 

Step 3:

 

Select the Transpose Check box.

 

 

 

 

 

Step 5:

 

All done here is the result..

 

 

 

 

Posted By

Jagadeesan Kandasamy