Transpose into a _working_ transposed array

[Fred Holmes]

I want to transpose an array into a _working_ transposed array. What
I find in the help is the TRANSPOSE function, that produces a
transposed array full of TRANSPOSE funstions, not an array full of the
original constants and functions, transposed in space (cell occupancy)
and in formula references. How do I go about doing the latter?

 

[Frans van Zelm]

Hi Fred,

Perhaps I don't get your question right. But ...
- select your source range
- select the first target cell
- Edit-Paste Special
check Transpose and [OK]

This sets all values and formulas 90 degrees rotated.

Frans