Spreadsheet: 859508d1707888983-turn-data-set-into-a-table-for-pivot-table-book2-5-
Sheet: Sheet1

 | Date | Factory Code | Factory name | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 |  | Date | Factory Code | Factory name | Product | Revenue
 | 2024-01-01 00:00:00 | EEVI | ABC1 | 10916.86985714286 | 4497.185714285714 | 0 | 0 | 0 | 1951.442857142857 |  | 2024-01-01 00:00:00 | EEVI | ABC1 | Product 1 | 10916.86985714286
 | 2024-01-01 00:00:00 | EGHV | [NAME] | 176645.7770149573 | 25955.72119658119 | 1335 | 4025 | 496.5 | 58251.84290598291 |  | 2024-01-01 00:00:00 | EEVI | ABC1 | Product 2 | 4497.185714285714
 | 2024-01-01 00:00:00 | EGS | ABC3 | 808835.3813157894 | 148580.2368421053 | 80707.2645 | 3756.077200000001 | 25796.0374 | 451136.2105263158 |  | 2024-01-01 00:00:00 | EEVI | ABC1 | Product 3 | 0
 | 2024-01-01 00:00:00 | EHCBI | [NAME] | 222663.6370666666 | 97001.4877124183 | 34660.1699 | 0 | 27707.1223 | 107240.0964705882 |  | 2024-01-01 00:00:00 | EEVI | ABC1 | Product 4 | 0
 | 2024-01-01 00:00:00 | EHCM | ABC5 | 228703.5284210526 | 54778.52631578947 | 6512.9821 | 1076.4921 | 1390.9031 | 136044.6052631579 |  | 2024-01-01 00:00:00 | EEVI | ABC1 | Product 5 | 0
 | 2024-01-01 00:00:00 | [NAME] | ABC6 | 76052.59280598292 | 8974.376068376068 | 143.136 | 3047.262 | 0 | 33066.72508547008 |  | 2024-01-01 00:00:00 | EEVI | ABC1 | Product 6 | 1951.442857142857
 | 2024-01-01 00:00:00 | EHTCB | ABC7 | 200998.3689473684 | 41610.97368421053 | 18223.1626 | 145.0293 | 1655.7894 | 118126.9736842105 |  | 2024-01-01 00:00:00 | EGHV | [NAME] | Product 1 | 176645.7770149573
 | 2024-01-01 00:00:00 | EHVL | ABC8 | 57838.32537899999 | 14965.59135 | 3465.5 | 0 | 0 | 29737.8883 |  | 2024-01-01 00:00:00 | EGHV | [NAME] | Product 2 | 25955.72119658119
 | 2024-01-01 00:00:00 | ERVI | ABC9 | 44098.10028571429 | 11680.91428571429 | 1923.1622 | 93.0471 | 1289.347 | 13674.88571428571 |  | 2024-01-01 00:00:00 | EGHV | [NAME] | Product 3 | 1335
 | 2024-01-01 00:00:00 | TLPP | ABC10 | 132892.4218421053 | 20121.02289473685 | 0 | 0 | 0 | 64958.76657894737 |  | 2024-01-01 00:00:00 | EGHV | [NAME] | Product 4 | 4025
 | 2024-01-01 00:00:00 | TLPT | ABC11 | 100768.7639473684 | 17084.43921052631 | 0 | 0 | 0 | 40739.37657894737 |  | 2024-01-01 00:00:00 | EGHV | [NAME] | Product 5 | 496.5
 | 2024-01-01 00:00:00 | TLSB | ABC12 | 268296.0539473685 | 34760.06473684211 | 0 | 0 | 0 | 191518.9878947368 |  | 2024-01-01 00:00:00 | EGHV | [NAME] | Product 6 | 58251.84290598291
 | 2024-01-01 00:00:00 | UBSP | ABC13 | 183853.2257894737 | 64711.26315789474 | 33411.1747 | 0 | 4245.8897 | 111704.7105263158 |  | 2024-01-01 00:00:00 | EGS | ABC3 | Product 1 | 808835.3813157894
 | 2024-01-01 00:00:00 | UBST | ABC14 | 165531.885 | 13177.65789473684 | 1072.8078 | 293.2056 | 628.2272 | 140594.6578947369 |  | 2024-01-01 00:00:00 | EGS | ABC3 | Product 2 | 148580.2368421053
 | 2024-01-01 00:00:00 | UCM | ABC15 | 80767.515 | 15249.36842105263 | 4879.2372 | 0 | 2437.5467 | 53840.47368421053 |  | 2024-01-01 00:00:00 | EGS | ABC3 | Product 3 | 80707.2645
 | 2024-01-01 00:00:00 | UGJT | ABC16 | 110128.737368421 | 22808.34210526316 | 3780.9999 | 0 | 219.3939 | 78716.6052631579 |  | 2024-01-01 00:00:00 | EGS | ABC3 | Product 4 | 3756.077200000001
 | 2024-01-01 00:00:00 | UHKI | ABC17 | 64885.81371428572 | 3495 | 671.6083 | 0 | 0 | 3797.071428571428 |  | 2024-01-01 00:00:00 | EGS | ABC3 | Product 5 | 25796.0374
 | 2024-01-01 00:00:00 | UKB | ABC18 | 72673.89815789473 | 13857.3947368421 | 3844.812 | 0 | 0 | 43841.84210526316 |  | 2024-01-01 00:00:00 | EGS | ABC3 | Product 6 | 451136.2105263158
 | 2024-01-01 00:00:00 | UKYT | ABC19 | 133693.9768421053 | 32909.78947368421 | 10064.0983 | 0 | 1670.9496 | 93433.31578947368 |  | 2024-01-01 00:00:00 | EHCBI | [NAME] | Product 1 | 222663.6370666666
 | 2024-01-01 00:00:00 | UNCM | ABC20 | 370653.3271052631 | 49526.34210526316 | 18340.8491 | 193.9657 | 2142.8178 | 280611 |  | 2024-01-01 00:00:00 | EHCBI | [NAME] | Product 2 | 97001.4877124183
 | 2024-01-01 00:00:00 | UPB | ABC21 | 162882.8670575163 | 39454.05392156863 | 14844.7077 | 0 | 14542.4148 | 94278.91346405228 |  | 2024-01-01 00:00:00 | EHCBI | [NAME] | Product 3 | 34660.1699
 | 2024-01-01 00:00:00 | USAT | ABC22 | 201350.9860526316 | 29504.78947368421 | 17502.1769 | 0 | 5692.9835 | 86938.15789473684 |  | 2024-01-01 00:00:00 | EHCBI | [NAME] | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCBI | [NAME] | Product 5 | 27707.1223
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCBI | [NAME] | Product 6 | 107240.0964705882
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCM | ABC5 | Product 1 | 228703.5284210526
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCM | ABC5 | Product 2 | 54778.52631578947
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCM | ABC5 | Product 3 | 6512.9821
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCM | ABC5 | Product 4 | 1076.4921
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCM | ABC5 | Product 5 | 1390.9031
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHCM | ABC5 | Product 6 | 136044.6052631579
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | ABC6 | Product 1 | 76052.59280598292
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | ABC6 | Product 2 | 8974.376068376068
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | ABC6 | Product 3 | 143.136
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | ABC6 | Product 4 | 3047.262
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | ABC6 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | ABC6 | Product 6 | 33066.72508547008
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHTCB | ABC7 | Product 1 | 200998.3689473684
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHTCB | ABC7 | Product 2 | 41610.97368421053
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHTCB | ABC7 | Product 3 | 18223.1626
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHTCB | ABC7 | Product 4 | 145.0293
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHTCB | ABC7 | Product 5 | 1655.7894
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHTCB | ABC7 | Product 6 | 118126.9736842105
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHVL | ABC8 | Product 1 | 57838.32537899999
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHVL | ABC8 | Product 2 | 14965.59135
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHVL | ABC8 | Product 3 | 3465.5
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHVL | ABC8 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHVL | ABC8 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | EHVL | ABC8 | Product 6 | 29737.8883
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | ERVI | ABC9 | Product 1 | 44098.10028571429
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | ERVI | ABC9 | Product 2 | 11680.91428571429
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | ERVI | ABC9 | Product 3 | 1923.1622
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | ERVI | ABC9 | Product 4 | 93.0471
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | ERVI | ABC9 | Product 5 | 1289.347
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | ERVI | ABC9 | Product 6 | 13674.88571428571
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPP | ABC10 | Product 1 | 132892.4218421053
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPP | ABC10 | Product 2 | 20121.02289473685
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPP | ABC10 | Product 3 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPP | ABC10 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPP | ABC10 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPP | ABC10 | Product 6 | 64958.76657894737
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPT | ABC11 | Product 1 | 100768.7639473684
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPT | ABC11 | Product 2 | 17084.43921052631
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPT | ABC11 | Product 3 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPT | ABC11 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPT | ABC11 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLPT | ABC11 | Product 6 | 40739.37657894737
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLSB | ABC12 | Product 1 | 268296.0539473685
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLSB | ABC12 | Product 2 | 34760.06473684211
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLSB | ABC12 | Product 3 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLSB | ABC12 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLSB | ABC12 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | TLSB | ABC12 | Product 6 | 191518.9878947368
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBSP | ABC13 | Product 1 | 183853.2257894737
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBSP | ABC13 | Product 2 | 64711.26315789474
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBSP | ABC13 | Product 3 | 33411.1747
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBSP | ABC13 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBSP | ABC13 | Product 5 | 4245.8897
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBSP | ABC13 | Product 6 | 111704.7105263158
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBST | ABC14 | Product 1 | 165531.885
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBST | ABC14 | Product 2 | 13177.65789473684
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBST | ABC14 | Product 3 | 1072.8078
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBST | ABC14 | Product 4 | 293.2056
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBST | ABC14 | Product 5 | 628.2272
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UBST | ABC14 | Product 6 | 140594.6578947369
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UCM | ABC15 | Product 1 | 80767.515
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UCM | ABC15 | Product 2 | 15249.36842105263
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UCM | ABC15 | Product 3 | 4879.2372
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UCM | ABC15 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UCM | ABC15 | Product 5 | 2437.5467
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UCM | ABC15 | Product 6 | 53840.47368421053
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UGJT | ABC16 | Product 1 | 110128.737368421
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UGJT | ABC16 | Product 2 | 22808.34210526316
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UGJT | ABC16 | Product 3 | 3780.9999
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UGJT | ABC16 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UGJT | ABC16 | Product 5 | 219.3939
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UGJT | ABC16 | Product 6 | 78716.6052631579
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UHKI | ABC17 | Product 1 | 64885.81371428572
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UHKI | ABC17 | Product 2 | 3495
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UHKI | ABC17 | Product 3 | 671.6083
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UHKI | ABC17 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UHKI | ABC17 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UHKI | ABC17 | Product 6 | 3797.071428571428
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKB | ABC18 | Product 1 | 72673.89815789473
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKB | ABC18 | Product 2 | 13857.3947368421
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKB | ABC18 | Product 3 | 3844.812
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKB | ABC18 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKB | ABC18 | Product 5 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKB | ABC18 | Product 6 | 43841.84210526316
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKYT | ABC19 | Product 1 | 133693.9768421053
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKYT | ABC19 | Product 2 | 32909.78947368421
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKYT | ABC19 | Product 3 | 10064.0983
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKYT | ABC19 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKYT | ABC19 | Product 5 | 1670.9496
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UKYT | ABC19 | Product 6 | 93433.31578947368
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UNCM | ABC20 | Product 1 | 370653.3271052631
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UNCM | ABC20 | Product 2 | 49526.34210526316
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UNCM | ABC20 | Product 3 | 18340.8491
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UNCM | ABC20 | Product 4 | 193.9657
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UNCM | ABC20 | Product 5 | 2142.8178
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UNCM | ABC20 | Product 6 | 280611
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UPB | ABC21 | Product 1 | 162882.8670575163
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UPB | ABC21 | Product 2 | 39454.05392156863
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UPB | ABC21 | Product 3 | 14844.7077
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UPB | ABC21 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UPB | ABC21 | Product 5 | 14542.4148
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | UPB | ABC21 | Product 6 | 94278.91346405228
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | USAT | ABC22 | Product 1 | 201350.9860526316
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | USAT | ABC22 | Product 2 | 29504.78947368421
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | USAT | ABC22 | Product 3 | 17502.1769
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | USAT | ABC22 | Product 4 | 0
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | USAT | ABC22 | Product 5 | 5692.9835
 |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | USAT | ABC22 | Product 6 | 86938.15789473684