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.
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.
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.
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.
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.
Thank You very much.