Switch around rows and columns

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 on the Home tab, choose  ​​​​​​​Copy.

Choose a new cell location for the transposed table and on the Home tab, select the arrow below Paste, and choose   Transpose Rows and Columns.

Delete the original table.