I cannot link to the sheet, have you tried Paste special Transpose?. Unless
I understand you incorrectly, you want data in a column copied to a row.
Paste the Values as well if it relates to formulas.