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