Select a block of data on a worksheet and click Transpose to swap the data in the rows with the data in the columns.
To transpose rows and columns in the selected cells
- Type data in the worksheet as below.
- Select the cells containing data with the pointer and click Home > Transpose.
- The data in rows will be swapped with the data in columns.