Swap data in rows with the data in columns

Select a block of data on a worksheet and click Transpose to swap the data in the rows with the data in the columns.

Steps

To transpose rows and columns in the selected cells

1. Type data in the worksheet as below.

   

2. Select the cells containing data with the pointer and click Home > Transpose.

   

3. The data in rows will be swapped with the data in columns.