2 Ways to Transpose in Excel

Use Function to Transpose

Step 1 Open the table to be set

Step 2 Select an area with the same size as the data to be transposed but opposite rows and columns

Step 3 Click the Formula TAB

Step 4 Select Insert Function below the TAB.

Step 5 Enter Transpose in search Function and click To go.

Step 6 Select the "TRANSPOSE" function and click "OK"

Step 7 In the Array column, select the data area to be transposed and hold down CTRL + Shift + Enter

Step 8 completes the data transpose

Use Copy and Paste to Transpose

Step 1 Copy the data.

Step 2 Right click and select transpose.