Copying Horizontal to paste vertical

**Staberinde** · 10-24-2009, 07:30 AM

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?

**zbor** · 10-24-2009, 07:34 AM

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

**Staberinde** · 10-24-2009, 07:39 AM

Thanks zbor

Thats worked a treat!

**Jenrich** · 11-05-2009, 09:49 PM

Hello,
Working on the same sort of thing. I can't seem to get the =transpose() formula to work properly. Do I need to fill down somehow?
I did hit ctl+shift+enter, which added the {} symbol, but it only fills in the cell I am in (M2 from example).

Thanks,
Jenrich
Copying Horizontal to paste vertical

**darkyam** · 11-05-2009, 10:16 PM

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.