How to transpose data in Excel
Posted On June 1, 2020
The following steps show how to transpose data in excel. Transposition refers to switching between rows and columns. For example, if row 1, column1 is A, row 2, column 2 is B, the transposition will be A in row1 column1 and B will be in row2 column2.
- copy a dataset
- before you paste, right click on the first destination cell
- click on Paste Special
- select Transpose, and click on OK