Copying Horizontal to paste vertical

Hi all

Bit of a simple question I expect so hoping someone can help.

I have a table of numbers that run horizontally from A2:J2. What I want to do is copy these to somewhere else on the sheet but to run Vertically so to run from say M2:M11

What I tried first was copying the whole selection of numbers area and repasting this by selecting the paste area as what I wanted vertically.

This works after a fashion but it pastes it both vertically AND horizontally in a table which overwrites the numbers that I have in the coumn to the right of the paste area I want. (Hope this makes sense)

Any ideas?

Right click -> paste spetial -> check Transpose

Or, if you need to do that all the time, from same place, go to M2, write =TRANSPOSE(A2:J2) and hit ctrl+shift+enter

Thanks zbor

Thats worked a treat!

zbor, you have to highlight the range you want transpose to work in first before using the formula. In this example, the OP would have to highlight M2:M11 before entering the formula for it to work right.

y.........