In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.
This can be useful especially if you have to copy rows from a database with a large number of fields. The transposed row-oriented result may be easier to read as the default column-oriented view:
- Highlight the cells that you want to copy.
- Then right-click on the cell where you'd like to paste the values and select Paste Special from the popup menu.
- Then select the Transpose checkbox and click on the OK button.