How to Transpose Rows and Columns in Excel 2013
You may have observed in Microsoft Office Excel you can copy or move the cells, rows, columns or ranges as per your convenience. However, there appears no trick available for swapping the same. Not anymore! Excel, if you are not aware, supports a one click operation to quickly swap rows, columns or ranges, known as ‘Transpose’.
The feature works with most versions of Excel such as Excel 2010, 2007, 2003.
Transpose feature in Excel 2013
Here, if you see I have created a spreadsheet in Excel 2013 in vertical orientation using a column style. We will proceed further and change the same into a horizontal row style. Here’s how.
From your Excel sheet, select the desired cells you would want to change.
Once done, Right-Click and select the ‘Copy’ option.
Next, Right-Click in any empty cell and choose Paste Options > Transpose as shown in the screen-shot below.
One of the highlights of Excel 2013 is that it will show you a preview of what the paste would look like before confirming the action.
If you do not see it, as an alternative step you can Right-Click an empty cell and Select ‘Paste Special’.
Then, from its window you can check the ‘Transpose’ box and Click OK.
You will now see your data transposed to a new layout style.
The same feature allows you to convert horizontal row data sheets into the vertical column style sheets too.
Also read 12 Basic Shortcuts That Will Make You An Excel Guru And Add Hours To Your Life