Select the table range
Copy the selected cells
Click the destination cell
Right-click and choose Paste Special
Check Transpose
Click OK
Use the TRANSPOSE function if you want a dynamic transposed table
Enter =TRANSPOSE(range) in the target area
Press Enter in Excel 365 or Ctrl+Shift+Enter in older versions