Hi,

several solutions are possible, depending on what you want.

For a one-off copy and paste, you can use Paste Special and tick the Transpose option.

For a dynamic solution, have a look at the TRANSPOSE() formula. You first select a range that is the correct number of rows and columns, then enter

=TRANSPOSE(Sheet1!A1:M5)

and hit CTRL-SHIFT-Enter to confirm. This is an array formula and has to be entered with CSE.

If you're not comfortable with the array formula, please post a small data sample that represents your layout and we can look at more alternatives.

cheers