Select E1:G3, enter the formula below, and press Ctrl +
Shift + Enter:

=TRANSPOSE($A$1:$C$3)

HTH
Jason
Atlanta, GA

-----Original 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


.