To transpose columns to rows in Excel, the best solution is Paste Special Menu.
Select and copy your data column, and click on a new location in your sheet.
Now, go to Edit | Paste Special.
Select the Transpose checkbox, and click OK.
Your column will transpose to row.