Thread
:
Function/macro to relocate RxC to CxR?
View Single Post
#
3
Don Guillett
Posts: n/a
Have you looked in help for transpose
--
Don Guillett
SalesAid Software
"J.Kearney" wrote in message
...
Anyone know (have) a function or macro to relocate entire arrays
from rows to columns?
I have a set of calculations that are just easier for me to deal with
in a column format.
i.e.:
A B C == A B C
---------- -----------
1 | x y z 1 | x a 6
2 | a b c 2 | y b 7
3 | 6 7 8 3 | z c 8
Thanks in advance.
Joe
Reply With Quote