Rotate Excel Data
Rotate Excel Data
(OP)
Does anyone know the process for rotating data on an EXCEL data sheet. I do not want to transpose the data. I want to just physically rotate the data.
Example left to right columns are labeled A B C D Rows within the columns are labeled 1, 2, 3, 4 as follows
A B C
1 3 4 5
2 6 8 2
3 2 9 1
I would like to rate 90 degrees clockwise to the following:
3 2 1
A 2 6 3
B 9 8 4
C 1 2 5
Thank you
Example left to right columns are labeled A B C D Rows within the columns are labeled 1, 2, 3, 4 as follows
A B C
1 3 4 5
2 6 8 2
3 2 9 1
I would like to rate 90 degrees clockwise to the following:
3 2 1
A 2 6 3
B 9 8 4
C 1 2 5
Thank you





RE: Rotate Excel Data
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
RE: Rotate Excel Data
CODE --> visualbasic
Enter as an array function and it will return a rotated version of RRange.
Please ask if anything isn't clear.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/