Harald

Edit - Cut
Edit - Pastespecial - Transpose

I must have looked at the Paste Special dialogue box ten thousand times but
have never seen 'Transpose

I've been too busy looking at 'Paste Link'

It worked beautifully.

Thanbk you very much

Peter Blunden

"Harald Staff" wrote:

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.