Edit - Cut
Edit - Pastespecial - Transpose

HTH. Best wishes Harald

"petergblunden" skrev i melding
...
Excellent. It worked.

If I want to permanently transform the data without keeping the original
array, is there a way I can do it ?

"petergblunden" wrote:

I wish to array dat by switching colums to rows and rows to columns
without
cutting and pasting for ever. Help please.