Firstly, please ask your question in the body of the message, not just in
the subject line. Blank messages will often be rejected or ignored.

The function you want is transpose, so you either want the TRANSPOSE
function, or you want to copy the data and use Edit/ Paste Special/
Transpose to copy in a transposed array.
--
David Biddulph

"tomcat" wrote in message
...