Transpose into a _working_ transposed array
 

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?

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

"Fred Holmes" wrote in message
...
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?