I would think that the TRANSPOSE array function would work for this. Use
Excel Help to find out more about the TRANSPOSE function.

Barb Reinhardt

"Michael Cantinotti" wrote:

hi,

I have to use a matrix that come from SPSS. I get a 75x75 symetric
matrix of distances between points (75 points). Zero are in the
diagonal. Only the lower part of the diagonal is diplayed. I exported
this matrix in Excel.

I am trying to recreate the full matrix (I need this for special
calculus). Is there a way to automate this (I would like to avoid
copy-past transpose, in order to avoid errors) ?

Point X12 should have the same value of X21, same applies for X13 and
X31, etc.

Any idea ? Thks,

Michael