Spreadsheet: 224207d1364486440-how-to-covert-lower-triangle-of-a-matrix-to-a-single-row-test
Sheet: Dosenb.SMO.CI_003_M1.zval

 | r1 | r2 | r3 | r4 | r5 | r6 | r7 | r8 | r9 | r10 | r11 | r12 | r13 | r14 | r15 | r16 | r17 | r18 | r19 | r20 | r21 | r22
r1 | 1 | 6.38492 | 6.2697 | 5.75529 | 4.89947 | 6.47166 | 4.4287 | 1.06655 | 5.45314 | 3.32395 | 4.95438 | 4.73682 | 5.82625 | 3.60534 | 1.81355 | 2.67931 | 1.19723 | -1.51393 | -1.75596 | 2.96373 | 2.67146 | 4.71724
r2 | 6.38492 | 1 | 13.4324 | 9.87204 | 7.51006 | 9.15676 | 10.7748 | 5.26121 | 15 | 6.44931 | 15 | 12.5871 | 13.3372 | 6.49512 | 2.48128 | 7.96459 | 2.91015 | 0.504099 | -0.12963 | 8.95259 | 3.20612 | 5.47047
r3 | 6.2697 | 13.4324 | 1 | 8.60525 | 5.86763 | 9.35497 | 6.33708 | 4.33038 | 14.1168 | 5.11053 | 11.6767 | 14.3718 | 13.8559 | 7.84038 | 4.64844 | 8.5473 | 5.0011 | 0.946955 | 2.59124 | 9.54105 | 5.57853 | 6.25891
r4 | 5.75529 | 9.87204 | 8.60525 | 1 | 8.83925 | 5.81052 | 4.82007 | 1.9639 | 8.13351 | 6.95056 | 7.91377 | 7.54223 | 8.48228 | 6.2628 | 4.94973 | 8.30776 | 3.66825 | 5.0863 | 4.79449 | 11.0827 | 6.2697 | 6.74225
r5 | 4.89947 | 7.51006 | 5.86763 | 8.83925 | 1 | 7.49884 | 6.94064 | 3.12494 | 6.5671 | 4.53327 | 5.72274 | 4.70081 | 4.35128 | 2.91835 | 1.72017 | 1.87588 | 0.45652 | -1.49918 | 0.364966 | 5.81899 | 1.69466 | 5.92039
r6 | 6.47166 | 9.15676 | 9.35497 | 5.81052 | 7.49884 | 1 | 6.70559 | 4.40628 | 9.57458 | 3.08231 | 6.64768 | 6.04715 | 5.96459 | 4.19743 | -0.626005 | 3.92022 | 0.348567 | -0.816424 | -1.2856 | 5.63483 | 3.59682 | 6.64678
r7 | 4.4287 | 10.7748 | 6.33708 | 4.82007 | 6.94064 | 6.70559 | 1 | 4.96186 | 8.16542 | 1.37406 | 7.24449 | 6.18477 | 6.69544 | 2.785 | 0.536918 | 1.92268 | 1.64864 | -2.53032 | -1.57899 | 3.37956 | 0.672431 | 6.0671
r8 | 1.06655 | 5.26121 | 4.33038 | 1.9639 | 3.12494 | 4.40628 | 4.96186 | 1 | 5.76839 | 4.73633 | 4.25098 | 2.08576 | 2.71857 | 3.05714 | -0.478742 | 2.89452 | 2.97768 | 2.80598 | 1.38367 | 5.81968 | -2.36365 | 1.40953
r9 | 5.45314 | 15 | 14.1168 | 8.13351 | 6.5671 | 9.57458 | 8.16542 | 5.76839 | 1 | 6.7348 | 14.7039 | 11.1843 | 12.4675 | 6.44503 | 2.23259 | 8.48228 | 2.27557 | 1.84531 | -0.241694 | 9.6766 | 2.82034 | 5.36719
r10 | 3.32395 | 6.44931 | 5.11053 | 6.95056 | 4.53327 | 3.08231 | 1.37406 | 4.73633 | 6.7348 | 1 | 11.2963 | 4.28265 | 6.95774 | 7.6037 | 7.99045 | 8.42724 | 3.40717 | 4.51712 | 3.07998 | 10.201 | -0.677806 | 3.08978
r11 | 4.95438 | 15 | 11.6767 | 7.91377 | 5.72274 | 6.64768 | 7.24449 | 4.25098 | 14.7039 | 11.2963 | 1 | 10.6169 | 11.5277 | 6.2759 | 4.31257 | 10.7174 | 3.04906 | 1.10849 | 0.854836 | 10.2007 | 2.55026 | 5.03557
r12 | 4.73682 | 12.5871 | 14.3718 | 7.54223 | 4.70081 | 6.04715 | 6.18477 | 2.08576 | 11.1843 | 4.28265 | 10.6169 | 1 | 1 | 6.68729 | 3.05341 | 8.72001 | 3.89853 | 1.10924 | 0.445484 | 6.52434 | 3.9014 | 6.00661
r13 | 5.82625 | 13.3372 | 13.8559 | 8.48228 | 4.35128 | 5.96459 | 6.69544 | 2.71857 | 12.4675 | 6.95774 | 11.5277 | 1 | 1 | 8.51028 | 4.43179 | 8.21928 | 6.6824 | 0.743663 | 0.0946141 | 6.81068 | 1.93874 | 6.11075
r14 | 3.60534 | 6.49512 | 7.84038 | 6.2628 | 2.91835 | 4.19743 | 2.785 | 3.05714 | 6.44503 | 7.6037 | 6.2759 | 6.68729 | 8.51028 | 1 | 5.25229 | 5.05792 | 6.47739 | 2.83733 | 7.73586 | 8.38791 | 3.84453 | 3.43339
r15 | 1.81355 | 2.48128 | 4.64844 | 4.94973 | 1.72017 | -0.626005 | 0.536918 | -0.478742 | 2.23259 | 7.99045 | 4.31257 | 3.05341 | 4.43179 | 5.25229 | 1 | 6.08444 | 4.00682 | 4.20211 | 6.23399 | 7.0298 | 1.28064 | 2.36533
r16 | 2.67931 | 7.96459 | 8.5473 | 8.30776 | 1.87588 | 3.92022 | 1.92268 | 2.89452 | 8.48228 | 8.42724 | 10.7174 | 8.72001 | 8.21928 | 5.05792 | 6.08444 | 1 | 3.38066 | 6.27431 | 2.81339 | 9.02656 | 2.57773 | 3.3606
r17 | 1.19723 | 2.91015 | 5.0011 | 3.66825 | 0.45652 | 0.348567 | 1.64864 | 2.97768 | 2.27557 | 3.40717 | 3.04906 | 3.89853 | 6.6824 | 6.47739 | 4.00682 | 3.38066 | 1 | -0.275377 | 4.87728 | 4.63811 | -1.01459 | 1.69526
r18 | -1.51393 | 0.504099 | 0.946955 | 5.0863 | -1.49918 | -0.816424 | -2.53032 | 2.80598 | 1.84531 | 4.51712 | 1.10849 | 1.10924 | 0.743663 | 2.83733 | 4.20211 | 6.27431 | -0.275377 | 1 | 6.61699 | 7.58955 | 1.97921 | 2.38137
r19 | -1.75596 | -0.12963 | 2.59124 | 4.79449 | 0.364966 | -1.2856 | -1.57899 | 1.38367 | -0.241694 | 3.07998 | 0.854836 | 0.445484 | 0.0946141 | 7.73586 | 6.23399 | 2.81339 | 4.87728 | 6.61699 | 1 | 7.90245 | 4.86669 | 1.97845
r20 | 2.96373 | 8.95259 | 9.54105 | 11.0827 | 5.81899 | 5.63483 | 3.37956 | 5.81968 | 9.6766 | 10.201 | 10.2007 | 6.52434 | 6.81068 | 8.38791 | 7.0298 | 9.02656 | 4.63811 | 7.58955 | 7.90245 | 1 | 3.45082 | 5.26592
r21 | 2.67146 | 3.20612 | 5.57853 | 6.2697 | 1.69466 | 3.59682 | 0.672431 | -2.36365 | 2.82034 | -0.677806 | 2.55026 | 3.9014 | 1.93874 | 3.84453 | 1.28064 | 2.57773 | -1.01459 | 1.97921 | 4.86669 | 3.45082 | 1 | 5.56213
r22 | 4.71724 | 5.47047 | 6.25891 | 6.74225 | 5.92039 | 6.64678 | 6.0671 | 1.40953 | 5.36719 | 3.08978 | 5.03557 | 6.00661 | 6.11075 | 3.43339 | 2.36533 | 3.3606 | 1.69526 | 2.38137 | 1.97845 | 5.26592 | 5.56213 | 1
required output |  | r1_r2 | r1_r3 | r1_r4 | r41_r5 | r1_r6 | r1_r7 | r1_r8 | r1_r9 | r1_r10 | ……..[NAME] | r2_r3 | r2_r4 | r2_r5 | r2_r6
 |  | 6.38492 | 6.2697 | 5.75529 | 4.89947 | 6.47166 | 4.4287 | 1.06655 | 5.45314 | 3.32395 | etc…. | 13.4324 | 9.87204 | 7.51006 | 9.15676 | etc…