Converting rows to columns in excel

1. Copy the whole table

2. Paste it to a different location with the Paste special option, the transport box ticked, as shown below.