Rotating axes in a worksheet

[Guest]

Is it possible to reverse the X- and Y- axes in an Excel worksheet? If so,
how?

For example, if I have:

A B C D E
1 2 3 4 5

I'd like to change it so it becomes

A 1
B 2
C 3
D 4
E 5

Thanks in advance,
Oliver.

 

[Guest]

Sure, copy all of the date then right-click, paste special, click the
transpose box.

 

[David Biddulph]

Copy/ Edit/ Paste Special/ Transpose

 

[Guest]

Ta muchly.

Typical - I've wanted to know how to do this for YEARS and no colleagues
have been able to help. As soon as I posted the question I stumbled across
the answer, so the responses must have filtered through to me by osmosis!