Matrix

[Guest]

I have a matrix and I would like to copy the info from the columns to the rows.

a1 b1 c1 d1 e1
a2 1 2 3 4
a3 2 3 4 5
a4 3 4 5 6
a5 4 5 6 7

Since a3 and d1 equal the same number and a4 and 31 equal the same number
and so on and so on. how can I auto fill the formula to fill across the row.
My formula is:

c1 =a3 d1 =a4 e1 =a5

 

[Bernd P]

Hello,

=INDEX(1:65536,COLUMN(),ROW())

Fill either the diagonal and the upper right triangle or the diagonal
and the lower left triangle of your matrix and put above formula into
all other cells. Replace 1:65536 by your matrix' range or its range
name if necessary.

Regards,
Bernd