copy single horizontal row into vertical column

[ftjjk]

I know I should know this but I can't remember.

How do I copy a horizontal row of data from one worksheet into a vertical row in a new worksheet?

[BigBas]

You can highlight the row, press CTRL+C to copy, right click into the destination cell, choose paste special, and choose transpose.

Let me know if that works

[ftjjk]

That works, thanks