Simplest solution I know

Highlight the cells of the array
Copy
Place cursor at location for top left of new array
Paste - Special - Select transpose

And voila - its done
Doncam

"J.Kearney" wrote in message
...
Anyone know (have) a function or macro to relocate entire arrays
from rows to columns?

Thanks in advance.
Joe