Tech Xpress

Convert Rows to Columns and vice-versa in MS Excel

If you do a lot of stuff with Excel, this tip will be really handy. Here's a really easy way to convert rows to columns in an Excel spreadsheet.

Convert Rows to Columns and vice versa in Excel - via Tech.Xpress (txpress.blogspot..com)Convert Rows to Columns and vice versa in Excel - via Tech.Xpress (txpress.blogspot..com)
1. Select all the rows and Copy them.
2. Open a new worksheet and click Edit >> Paste Special from the menu. This open the 'Paste Special' box.

Excel's Past Special box - via Tech.Xpress (txpress.blogspot..com)
3. In the 'Paste Special' box, tick the Transpose check box. Click ok.

That's it! All row data is now converted to columns. This also works for converting Column data to Rows.

Home
posted by Vijeesh Ravindran, Thursday, October 02, 2008


1 Comments:

Comment by Anonymous Anonymous on October 27, 2008 at 11:49 AM  
Very useful tool... At other times, this would have taken hours for me to do.

Thank You very much.