Maybe he means something like this:

Original formulas in A1 to A25.

Transpose from B1 to Z1,
*And* arrays are *linked*.

Enter in B1, and copy across to Z1:

=INDEX($A$1:$A$25,COLUMNS($A:A))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Now I see what you meant by the "excel transposes cell ranges within
formulas"

You are correct if you also transpose the data the formulas are
referencing.

But OP states

all the formulas in the cells stay the same and original and
transposed arrays are linked to each other

so maybe does want the entire array including formulas transposed?

I duuno<g


Gord

On Thu, 31 Aug 2006 14:20:02 -0700, David Billigmeier

wrote:

Hi Gord -
I believe it was myself who originally mis-understood the subject's post.
I
must have read over the part when he said he wanted the formula's to stay
the
exact same.

With respect to your example, however, select the entire range (A1:C20).
Then go to a new cell (say D1) and do a Paste Special-Transpose. Excel
will
not only transpose the raw data but it will update each of the formula's
to
work with the new range.

For example the first formula in the previous range was located in C1 and
read "=A1+B1". After the transpose this will be located in D3 and read
"=D1+D2." This is what I mean by "excel transposes cell ranges within
formula's". Sorry for any confusion.

Gord Dibben MS Excel MVP