Convert a Column to a Row in Excel

May 16, 2011

Those of you who use Excel are going to love this one!

To convert a Column to a Row (or vise-versa) follow these simple steps:

1. Select all the cells which you would like to convert.
2. Copy  (Ctrl + C)
3. Right-click in the cell where you want to the rows to start, and select “Paste Special”.
4. Check the box at the bottom next to “Transpose”.
5. Click OK.

There you go!

Do the exact same steps if you want to transpose Rows to Columns.