-
Select the relevant rows and columns with labels, on the Home tab, choose Copy.
-
Choose a new cell location for the transposed table and on the Home tab, select the arrow next to Paste, and choose Transpose.
-
Delete the original table.
-
Select the relevant rows and columns with labels and go to Home > Copy .
-
Choose a new cell location for the transposed table and on the Home tab, select the arrow below Paste, and choose Transpose.
-
Delete the original table.