Did you know Transpose Columns and Rows?
STEP - 1
- Select the data you want to transpose, and copy it (CTRL-C).
STEP - 2
- Click on the cell where you want to place the data, then right-click to get the dropdown menu. From that menu, select “Paste Special’’
STEP - 3
- From the Paste Special menu, click the “Transpose” checkbox in the lower right-hand corner, then click OK.
Leave a comment