Since I don't know what you're doing now, I don't know what you need to do
differently. But try this:
Select the data to transpose, use Edit | Copy or Ctrl+C and then click an
empty cell elsewhere and use Edit | Paste Special with the Transpose box
checked. Click [OK].
That should work.

"Sarah" wrote:

The Transpose option is greyed out - what do i need to do differently to
paste my row as a column? Thanks for any help!