Another way (non-array) ..

Assuming source table is in Sheet1, A1:C3

In Sheet2
---------
Put in A1:
=OFFSET(Sheet1!$A$1,COLUMNS($A$1:A1)-1,ROWS($A$1:A1)-1)
Copy A1 across to C1, fill down to C3

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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