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!



"David Biddulph" wrote:

Copy/ Edit/ Paste Special/ Transpose
--
David Biddulph

"Oliver Bouckley" wrote in
message ...
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.