-
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.