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.

  1. copy a dataset
  2. before you paste, right click on the first destination cell
  3. click on Paste Special
  4. select Transpose, and click on OK