Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recreate the upper part of a symetric data matrix 75x75
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |