Based on Roger's reply, for your second rotation:

=INDEX($A$1:$C$3,COLUMN(A1),4-ROW(A1))

"Roger Govier" wrote:

Hi Andrew

With your existing data in A1:C3, enter in say cell F1

=INDEX($A$1:$C$3,4-COLUMN(A1),ROW(A1))

Copy across through G1:H1
Copy F1:H1 to F2:F3

--
Regards

Roger Govier


wrote in message
ups.com...
I need to rotate data in a spreadsheet, but not like transpose. What
I have is:

1 2 3
4 5 6
7 8 9

And I need to change it to:

7 4 1
8 5 2
9 6 3

or

3 6 9
2 5 8
1 4 7
In essence, landscape to portrait, is this possible?