" wrote:

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?

Hi,
If you have have a large volume of data, the best way to do it
would be to scan the rows and put the cell values in columns appropriately -
with a Macro.

The macro needs to be worked out.

VJ