Spreadsheet: 730951d1620066685-dynamic-formula-to-split-data-in-column-c-and-repeat-the-remaining-columns-split-range
Sheet: Data

Date | Company | Truck | No1 | No2 | No3 | No4 | Quantity
2021-04-01 00:00:00 | Company1 | 6578, 7496 | 20.66 | 29.51 | 4398 |  | 37.46 |  |  | Company1 | 6578, 7496 | 20.66 | 29.51 | 4398 | 3377.396 | 37.46
2021-04-01 00:00:00 | Company2 | 2951 | 20.21 | 32.35 | 4106 |  | 48.02 |  | 2021-04-01 00:00:00 | Company2 | 2951 | 20.21 | 32.35 | 4106 | 3166.6392 | 48.02
2021-04-01 00:00:00 | Company3 | 2971 | 16.44 | 23.76 | 4484 |  | 26.78 |  | 2021-04-01 00:00:00 | Company3 | 2971 | 16.44 | 23.76 | 4484 | 3657.7256 | 26.78
2021-04-01 00:00:00 | Company4 | 2473, 7416 | 18.26 | 30.33 | 4432 |  | 106.54 |  | 2021-04-01 00:00:00 | Company4 | 2473 | 18.26 | 30.33 | 4432 | 3523.7476 | 106.54
2021-04-01 00:00:00 | Company5 | 9241, 8162, 2493, 3697 | 22.75 | 31 | 4186 |  | 222.44 |  | 2021-04-01 00:00:00 | Company4 | 7416 | 18.26 | 30.33 | 4432 | 3523.7476 | 106.54
2021-04-02 00:00:00 | Company4 | 3724, 1564, 4571, 8947 | 20.51 | 29.65 | 4432 |  | 192.32 |  | 2021-04-01 00:00:00 | Company5 | 9241 | 22.75 | 31 | 4186 | 3110.38 | 222.44
2021-04-02 00:00:00 | Company2 | 7415 | 18.85 | 34.31 | 4106 |  | 42 |  | 2021-04-01 00:00:00 | Company5 | 8162 | 22.75 | 31 | 4186 | 3110.38 | 222.44
2021-04-02 00:00:00 | Company6 | 5312 | 25.14 | 24 | 4596 |  | 42.14 |  | 2021-04-01 00:00:00 | Company5 | 2493 | 22.75 | 31 | 4186 | 3110.38 | 222.44
2021-04-02 00:00:00 | Company1 | 6578, 7496 | 20.39 | 30.15 | 4398 |  | 61.1 |  | 2021-04-01 00:00:00 | Company5 | 3697 | 22.75 | 31 | 4186 | 3110.38 | 222.44
2021-04-02 00:00:00 | Company7 | 1589 | 22.71 | 29.71 | 4411 |  | 33.04 |  | 2021-04-02 00:00:00 | Company4 | 3724 | 20.51 | 29.65 | 4432 | 3411.8326 | 192.32
2021-04-03 00:00:00 | Company5 | 5761 | 21.87 | 31.39 | 4186 |  | 57.44 |  | 2021-04-02 00:00:00 | Company4 | 1564 | 20.51 | 29.65 | 4432 | 3411.8326 | 192.32
2021-04-03 00:00:00 | Company3 | 8129, 9481 | 16 | 22.85 | 4484 |  | 75.74 |  | 2021-04-02 00:00:00 | Company4 | 4571 | 20.51 | 29.65 | 4432 | 3411.8326 | 192.32
2021-04-03 00:00:00 | Company1 | 6578, 7496 | 20.13 | 29.15 | 4398 |  | 36.4 |  | 2021-04-02 00:00:00 | Company4 | 8947 | 20.51 | 29.65 | 4432 | 3411.8326 | 192.32
2021-04-04 00:00:00 | Company4 | 6741, 7492 | 20.41 | 30.45 | 4486 |  | 95.74 |  | 2021-04-02 00:00:00 | Company2 | 7415 | 18.85 | 34.31 | 4106 | 3229.852 | 42
2021-04-04 00:00:00 | Company1 | 6578, 7496 | 21.77 | 30.18 | 4347 |  | 57.66 |  | 2021-04-02 00:00:00 | Company6 | 5312 | 25.14 | 24 | 4596 | 3304.3068 | 42.14
2021-04-04 00:00:00 | Company7 | 1589 | 22.15 | 29.71 | 4466 |  | 33 |  | 2021-04-02 00:00:00 | Company1 | 6578, 7496 | 20.39 | 30.15 | 4398 | 3390.734 | 61.1
2021-04-05 00:00:00 | Company4 | 8524, 9516, 7416, 2473 | 19.61 | 30.45 | 4486 |  | 201.82 |  | 2021-04-02 00:00:00 | Company7 | 1589 | 22.71 | 29.71 | 4411 | 3286.1737 | 33.04
2021-04-05 00:00:00 | Company6 | 9423, 9138 | 23.21 | 23.31 | 4588 |  | 76.52 |  | 2021-04-03 00:00:00 | Company5 | 5761 | 21.87 | 31.39 | 4186 | 3151.9864 | 57.44
2021-04-05 00:00:00 | Company1 | 6578, 7496 | 20.17 | 29.55 | 4347 |  | 58.56 |  | 2021-04-03 00:00:00 | Company3 | 8129 | 16 | 22.85 | 4484 | 3679.84 | 75.74
2021-04-06 00:00:00 | Company4 | 1564, 8126 | 18.55 | 30.37 | 4486 |  | 94.5 |  | 2021-04-03 00:00:00 | Company3 | 9481 | 16 | 22.85 | 4484 | 3679.84 | 75.74
2021-04-06 00:00:00 | Company6 | 5312 | 22.11 | 26.71 | 4588 |  | 40.88 |  | 2021-04-03 00:00:00 | Company1 | 6578, 7496 | 20.13 | 29.15 | 4398 | 3403.578 | 36.4
2021-04-06 00:00:00 | Company8 | 8462, 3598 | 20.89 | 29.79 | 4480 |  | 76.32 |  | 2021-04-04 00:00:00 | Company4 | 6741 | 20.41 | 30.45 | 4486 | 3459.7852 | 95.74
2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 |  | 33.94 |  | 2021-04-04 00:00:00 | Company4 | 7492 | 20.41 | 30.45 | 4486 | 3459.7852 | 95.74
2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 |  | 36.4 |  | 2021-04-04 00:00:00 | Company1 | 6578, 7496 | 21.77 | 30.18 | 4347 | 3282.6647 | 57.66
2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 |  | 43.9 |  | 2021-04-04 00:00:00 | Company7 | 1589 | 22.15 | 29.71 | 4466 | 3356.728 | 33
2021-04-07 00:00:00 | Company4 | 6741, 2951 | 18.84 | 30.73 | 4387 |  | 100.1 |  | 2021-04-05 00:00:00 | Company4 | 8524 | 19.61 | 30.45 | 4486 | 3500.0092 | 201.82
2021-04-07 00:00:00 | Company2 | 3984 | 18.19 | 33.67 | 4056 |  | 49.62 |  | 2021-04-05 00:00:00 | Company4 | 9516 | 19.61 | 30.45 | 4486 | 3500.0092 | 201.82
2021-04-07 00:00:00 | Company8 | 8462, 3598 | 17.71 | 28.31 | 4429 |  | 77.48 |  | 2021-04-05 00:00:00 | Company4 | 7416 | 19.61 | 30.45 | 4486 | 3500.0092 | 201.82
2021-04-07 00:00:00 | Company1 | 6578, 7496 | 19.55 | 28.77 | 4436 |  | 34.72 |  | 2021-04-05 00:00:00 | Company4 | 2473 | 19.61 | 30.45 | 4486 | 3500.0092 | 201.82
2021-04-07 00:00:00 | Company7 | 1589 | 21.18 | 29.15 | 4352 |  | 35.84 |  | 2021-04-05 00:00:00 | Company6 | 9423 | 23.21 | 23.31 | 4588 | 3397.327 | 76.52
 |  |  |  |  |  |  |  |  | 2021-04-05 00:00:00 | Company6 | 9138 | 23.21 | 23.31 | 4588 | 3397.327 | 76.52
 |  |  |  |  |  |  |  |  | 2021-04-05 00:00:00 | Company1 | 6578, 7496 | 20.17 | 29.55 | 4347 | 3360.8887 | 58.56
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company4 | 1564 | 18.55 | 30.37 | 4486 | 3553.306 | 94.5
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company4 | 8126 | 18.55 | 30.37 | 4486 | 3553.306 | 94.5
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company6 | 5312 | 22.11 | 26.71 | 4588 | 3453.757 | 40.88
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company8 | 8462 | 20.89 | 29.79 | 4480 | 3430.9042 | 76.32
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company8 | 3598 | 20.89 | 29.79 | 4480 | 3430.9042 | 76.32
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 | 3354.044100000001 | 33.94
 |  |  |  |  |  |  |  |  | 2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 | 3267.0848 | 36.4
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 | 3232.0368 | 43.9
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company4 | 6741 | 18.84 | 30.73 | 4387 | 3458.3764 | 100.1
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company4 | 2951 | 18.84 | 30.73 | 4387 | 3458.3764 | 100.1
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company2 | 3984 | 18.19 | 33.67 | 4056 | 3219.6238 | 49.62
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company8 | 8462 | 17.71 | 28.31 | 4429 | 3548.6359 | 77.48
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company8 | 3598 | 17.71 | 28.31 | 4429 | 3548.6359 | 77.48
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company1 | 6578, 7496 | 19.55 | 28.77 | 4436 | 3462.801 | 34.72
 |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | Company7 | 1589 | 21.18 | 29.15 | 4352 | 3315.4508 | 35.84