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:
- Select all the cells which you would like to convert.
- Copy (Ctrl + C)
- Right-click in the cell where you want to the rows to start, and select “Paste Special”.
- Check the box at the bottom next to “Transpose”.
- Click OK.
There you go!
Do the exact same steps if you want to transpose Rows to Columns.