Rotating axes in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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!
 
Back
Top