Spreadsheet: 809153d1670937865-convert-from-tables-to-another-table-problem-dc_52779
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =LET(rng,A6:P15,DROP(REDUCE("",SEQUENCE(ROWS(rng)),LAMBDA(x,y,LET(a,INDEX(rng,y,),b,IFERROR(TEXTSPLIT(TEXTJOIN("|",,a)," ","|"),""),VSTACK(x,TRANSPOSE(IFERROR(--b,b)))))),1))
CHB-8 | 8 10 12 15 | 400 460 510 560 | 0.8 0.7 0.6 05 | 485 55.0 60.0 65.0 | 1.6 13 1.1 0.8 | 575 640 685 74.0 | 2.5 1.8 1.4 1.0 | 66.0 725 77.0 825 | 33 2.4 1.9 1.4 | 750 81.0 86.0 913 | 4.5 32 25 1.8 | 84.0 90.0 945 100.0 | 5.7 4.0 32 23 | 93.0 985 103.0 109.0 | 72 5.0 3.9 2.8 |  |  | 8 | 400 | 0.8 | 485 | 1.6 | 575 | 2.5 | 66 | 33 | 750 | 4.5 | 84 | 5.7 | 93 | 72
CHB-10 | 8 10 12 15 | 505 570 635 710 | 0.9 0.8 0.7 0.6 | 67.0 72.0 78.0 85.0 | 1.8 15 12 0.9 | 815 86.0 92.0 100.0 | 2.8 2.0 1.6 12 | 96.0 101.0 107.0 115.0 | 3.7 2.7 2.1 1.6 | 1105 116.0 1225 131.0 | 5.0 3.6 2.8 2.0 | 1215 132.0 1385 1465 | 63 45 35 25 | 143.0 1485 154.0 162.0 | 8.0 5.6 43 3.1 |  |  | 10 | 460 | 0.7 | 55 | 13 | 640 | 1.8 | 725 | 2.4 | 81 | 32 | 90 | 4 | 985 | 5
CHB-15 | 8 10 12 15 | [PHONE] 1170 | 1.9 15 13 1.0 | 1065 116.0 126.0 140.0 | 2.9 22 1.8 15 | 128.0 139.0 149.0 168.7 | 4.1 3.1 25 25 | 151.0 161.0 1725 189.0 | 5.6 4.1 3.4 2.6 | 175.0 185.7 1970 214.0 | 7.4 5.4 4.3 33 | 198.8 210.0 222.0 | 9.4 6.8 5.4 | 223.0 | 11.8 |  |  | 12 | 510 | 0.6 | 60 | 1.1 | 685 | 1.4 | 77 | 1.9 | 86 | 25 | 945 | 32 | 103 | 3.9
CHB-20 | 8 10 12 15 | 1090 1180 1250 1370 | 12 0.9 0.7 0.6 | 139$ 148.0 157.0 167.8 | 1.9 1.4 1.1 0.8 | 1715 180.0 190.0 201.9 | 2.8 2.0 1.6 12 | 2085 2155 224.0 237.0 | 4.1 2.8 22 1.6 | 246.7 2525 260.0 273.6 | 5.6 3.9 2.9 2.1 | 286.4 291.6 300.0 311.0 | 75 5.1 3.8 2.6 | 329.0 333.0 339.7 350.0 | 9.7 65 4.8 33 |  |  | 15 | 560 | 5 | 65 | 0.8 | 74 | 1 | 825 | 1.4 | 913 | 1.8 | 100 | 23 | 109 | 2.8
CHB-25 | 8 10 12 15 | 1380 1430 1520 1620 | 1.4 1.0 0.8 0.7 | 1765 183.0 1912 202.0 | 22 1.6 13 0.9 | 2145 222.0 2312 244.0 | 32 23 1.8 1.4 | 1542 262.4 2715 2842 | 4.7 32 25 1.8 | 2975 305.0 3125 325.0 | 6.4 45 33 2.4 | 341.0 347.0 3545 366.0 | 8.6 5.9 4.4 30 | 385.0 391.0 3965 407.0 | 113 75 55 3.8 |  | CHB-10 | 8 | 505 | 0.9 | 67 | 1.8 | 815 | 2.8 | 96 | 3.7 | 1105 | 5 | 1215 | 63 | 143 | 8
CHB-30 | 8 10 12 15 | 1550 1695 1810 1970 | 1.1 12 1.0 0.7 | 200.0 111.0 221.7 239.0 | 25 1.8 1.4 1.1 | 244.0 2543 264.0 281.7 | 3.7 2.6 2.0 15 | 290.0 298.0 310.0 325.0 | 5.1 35 2.7 1.9 | 335.8 3465 355.7 372.0 | 6.8 4.7 35 25 | 384.0 3945 403.0 419.8 | 8.8 60 45 33 | 436.0 443.9 454.0 468.0 | 112 7.6 5.6 3$ |  |  | 10 | 570 | 0.8 | 72 | 15 | 86 | 2 | 101 | 2.7 | 116 | 3.6 | 132 | 45 | 1485 | 5.6
CHB-40 | 8 10 12 15 | 2070 2240 237.6 254.4 | 0.8 0.6 05 0.4 | 272.0 285.6 296.4 315.6 | 13 0.9 0.7 05 | 337.0 348.0 362.4 3792 | 2.0 1.4 1.1 0.8 | 408.0 417.6 428.4 4452 | 2.9 2.0 15 1.0 | 486.0 489.6 501.6 518.4 | 4.0 2.7 2.0 1.4 | 5560 570.0 579.6 592.8 | 53 35 2.6 1.8 | 648.0 652.8 657.6 668.4 | 6.9 4.6 33 22 |  |  | 12 | 635 | 0.7 | 78 | 12 | 92 | 1.6 | 107 | 2.1 | 1225 | 2.8 | 1385 | 35 | 154 | 43
CHB-50 | 8 10 12 15 | 2530 2660 2835 296.8 | 0.6 0.5 0.4 03 | 327D 340JO 358J0 3760 | 1.6 1.2 0.9 0.6 | 407.0 420.0 437.0 453.0 | 23 1.6 13 0.9 | 492.0 505.8 520.0 534.0 | 3.3 2.3 1.7 12 | 588.0 598.0 610.0 623.0 | 4.4 30 2.2 1.5 | 684.0 694.0 701.0 714.0 | 5.8 3.8 2.8 1.9 | 779.0 778.0 794.0 804.0 | 73 4.9 3.5 2.4 |  |  | 15 | 710 | 0.6 | 85 | 0.9 | 100 | 12 | 115 | 1.6 | 131 | 2 | 1465 | 25 | 162 | 3.1
CIIB-60 | 8 10 12 15 | 3160 3340 3500 3780 | 0.7 0.6 05 0.4 | 4090 4250 442.8 4680 | 1.8 13 1.0 0.7 | 499.0 515.0 531.6 558.0 | 2.6 1.8 1.4 1.0 | 594.0 609.0 622.8 648.0 | 3.7 25 1.9 13 | 6910 702.0 718.8 742.8 | 4.9 33 2.4 1.7 | 798.0 804.0 8172 833.4 | 6.4 42 33 23 | 906.0 914.0 920.4 9432 | S3 5.4 3.9 2.7 |  | CHB-15 | 8 | 860 | 1.9 | 1065 | 2.9 | 128 | 4.1 | 151 | 5.6 | 175 | 7.4 | 198.8 | 9.4 | 223 | 11.8
CUB-75 | 8 10 12 15 | 4100 4310 4530 5000 | 0.8 0.6 0.5 0.5 | 5290 550.8 573.6 610.8 | 1.9 13 1.0 0.8 | 646.0 6672 688.8 722.4 | 2.8 1.9 1.4 1.0 | 764.0 788.4 807.6 840.0 | 3.8 2.6 2.0 1.4 | 8950 909.6 932.4 962.4 | 5.1 35 2.6 1.8 | 1033.0 1041.6 105S.4 10992 | 6.7 45 33 23 | 1174.0 11832 1192.8 1221.6 | 8.6 5.7 4.1 2.8 |  |  | 10 | 945 | 15 | 116 | 22 | 139 | 3.1 | 161 | 4.1 | 185.7 | 5.4 | 210 | 6.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1040 | 13 | 126 | 1.8 | 149 | 25 | 1725 | 3.4 | 1970 | 4.3 | 222 | 5.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 1170 | 1 | 140 | 15 | 168.7 | 25 | 189 | 2.6 | 214 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHB-20 | 8 | 1090 | 12 | 139$ | 1.9 | 1715 | 2.8 | 2085 | 4.1 | 246.7 | 5.6 | 286.4 | 75 | 329 | 9.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1180 | 0.9 | 148 | 1.4 | 180 | 2 | 2155 | 2.8 | 2525 | 3.9 | 291.6 | 5.1 | 333 | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1250 | 0.7 | 157 | 1.1 | 190 | 1.6 | 224 | 22 | 260 | 2.9 | 300 | 3.8 | 339.7 | 4.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 1370 | 0.6 | 167.8 | 0.8 | 201.9 | 12 | 237 | 1.6 | 273.6 | 2.1 | 311 | 2.6 | 350 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHB-25 | 8 | 1380 | 1.4 | 1765 | 22 | 2145 | 32 | 1542 | 4.7 | 2975 | 6.4 | 341 | 8.6 | 385 | 113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1430 | 1 | 183 | 1.6 | 222 | 23 | 262.4 | 32 | 305 | 45 | 347 | 5.9 | 391 | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1520 | 0.8 | 1912 | 13 | 2312 | 1.8 | 2715 | 25 | 3125 | 33 | 3545 | 4.4 | 3965 | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 1620 | 0.7 | 202 | 0.9 | 244 | 1.4 | 2842 | 1.8 | 325 | 2.4 | 366 | 30 | 407 | 3.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHB-30 | 8 | 1550 | 1.1 | 200 | 25 | 244 | 3.7 | 290 | 5.1 | 335.8 | 6.8 | 384 | 8.8 | 436 | 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1695 | 12 | 111 | 1.8 | 2543 | 2.6 | 298 | 35 | 3465 | 4.7 | 3945 | 60 | 443.9 | 7.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1810 | 1 | 221.7 | 1.4 | 264 | 2 | 310 | 2.7 | 355.7 | 35 | 403 | 45 | 454 | 5.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 1970 | 0.7 | 239 | 1.1 | 281.7 | 15 | 325 | 1.9 | 372 | 25 | 419.8 | 33 | 468 | 3$
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHB-40 | 8 | 2070 | 0.8 | 272 | 13 | 337 | 2 | 408 | 2.9 | 486 | 4 | 5560 | 53 | 648 | 6.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2240 | 0.6 | 285.6 | 0.9 | 348 | 1.4 | 417.6 | 2 | 489.6 | 2.7 | 570 | 35 | 652.8 | 4.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 237.6 | 5 | 296.4 | 0.7 | 362.4 | 1.1 | 428.4 | 15 | 501.6 | 2 | 579.6 | 2.6 | 657.6 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 254.4 | 0.4 | 315.6 | 5 | 3792 | 0.8 | 4452 | 1 | 518.4 | 1.4 | 592.8 | 1.8 | 668.4 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHB-50 | 8 | 2530 | 0.6 | 327D | 1.6 | 407 | 23 | 492 | 3.3 | 588 | 4.4 | 684 | 5.8 | 779 | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2660 | 0.5 | 340JO | 1.2 | 420 | 1.6 | 505.8 | 2.3 | 598 | 30 | 694 | 3.8 | 778 | 4.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 2835 | 0.4 | 358J0 | 0.9 | 437 | 13 | 520 | 1.7 | 610 | 2.2 | 701 | 2.8 | 794 | 3.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 296.8 | 3 | 3760 | 0.6 | 453 | 0.9 | 534 | 12 | 623 | 1.5 | 714 | 1.9 | 804 | 2.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIIB-60 | 8 | 3160 | 0.7 | 4090 | 1.8 | 499 | 2.6 | 594 | 3.7 | 6910 | 4.9 | 798 | 6.4 | 906 | S3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 3340 | 0.6 | 4250 | 13 | 515 | 1.8 | 609 | 25 | 702 | 33 | 804 | 42 | 914 | 5.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 3500 | 5 | 442.8 | 1 | 531.6 | 1.4 | 622.8 | 1.9 | 718.8 | 2.4 | 8172 | 33 | 920.4 | 3.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 3780 | 0.4 | 4680 | 0.7 | 558 | 1 | 648 | 13 | 742.8 | 1.7 | 833.4 | 23 | 9432 | 2.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CUB-75 | 8 | 4100 | 0.8 | 5290 | 1.9 | 646 | 2.8 | 764 | 3.8 | 8950 | 5.1 | 1033 | 6.7 | 1174 | 8.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 4310 | 0.6 | 550.8 | 13 | 6672 | 1.9 | 788.4 | 2.6 | 909.6 | 35 | 1041.6 | 45 | 11832 | 5.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 4530 | 0.5 | 573.6 | 1 | 688.8 | 1.4 | 807.6 | 2 | 932.4 | 2.6 | 105S.4 | 33 | 1192.8 | 4.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 5000 | 0.5 | 610.8 | 0.8 | 722.4 | 1 | 840 | 1.4 | 962.4 | 1.8 | 10992 | 23 | 1221.6 | 2.8