Excel Help

[goodlife]

Anyone know a shortcut in MS Excel that switches rows of data into columns of data?

Currently looks like:

A B C B E ... and so on
10 11 12 13 14

Want it to look like

A 10
B 11
C 12
D 13
E 14

Please don't suggest cut&paste as that will take forever!

[goodlife]

Nope - Pivot tables take the A,B,C as fields and only allow one field per column.

Now sorted however - a clever at work pointed out the Excel feature. Highlight the two rows, copy, click outside the copy area, paste special, check the 'transpose' box, OK. Job done!

[goodlife]

Thanks for the transpose tips everyone.

Also for pointing out typos.
Also for the cut&paste sarcasm.

<small>buggers</small>