rows to columns in excel

baby-mechanic

Hi folks

I've created table in excel, and need to change the information round so that the current rows become columns, and the columns become rows.
(effectively rotating it through 90 degres, if that makes sense !)

Have tried the pivot function to no avail

Any suggestions, apart from rewriting the whole table ?

HoofeHearted

Try the instructions here.

bskelhorn_2

Hi there,

if you highlight the rows and then choose copy. Once they are selected right click where you want them to appear and choose "paste special" then from the menu click "transpose" and away you go.

baby-mechanic

Thanks for that.

Always wondered if I'd ever use 'Paste special' !!

bskelhorn_2

Once you have used it once you will never stop!

littlepanther

I agree. Paste Link is useful too.

Transpose is so underused.

Some useful Excel tutorials at http://!!!!!!!/bUV4VQ