Spreadsheet: 730945d1620063235-dynamic-formula-to-split-data-in-column-c-and-repeat-the-remaining-columns-split-range
Sheet: Report

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