Google Sheets – Copy Lower Triangle to Upper Triangle

google sheets

I have a matrix in Google Drive Spreadsheets. Only the lower triangle is filled. I would like to copy the values of the lower triangle to the upper triangle. How can I achieve that?

Example:

Initial matrix:

enter image description here

Objective:

enter image description here

Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Aoy6Mj_UZoTEdDA1emRsQ2F0cU13RG9HVDF5MlBFYnc&usp=sharing

Best Answer

Copied from link in original post :

WA58768 example

C2 formula: =INDEX(INDIRECT(ADDRESS(2,$A2+1)&":"&ADDRESS(10,$A2+1)),MATCH(C$1,$A$2:$A$10,0))

Related Topic