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!

[Plotloss]

Pivot Tables should sort it...

[Shadytree]

Copy
Right Click
Paste Special
Tick 'Transpose' Box
Ok

edited to say , sorry didn't read the small print

>> Edited by Shadytree on Wednesday 15th September 15:41

[victormeldrew]

Yup, paste special, transpose.

It isn't going to change that second B into a D though

>> Edited by victormeldrew on Wednesday 15th September 15:43

[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>