Spreadsheet: 834327d1687678528-sum-up-revenue-of-customers-by-year-from-another-sheet-of-financial-data-test-file-for-power-query-aligw
Sheet: Merge1

Customer Code | 2023 | 2022 | 2021 | 2020 | 2019 | 2018 | 1/2023 | 2/2023 | 3/2023 | 4/2023 | 5/2023
1008079 | -7425 | -17477.5 | 14587.5 |  |  |  |  |  | -7425
1008804 |  |  |  |  |  | 1220.96
1008812 | -4629.5 |  |  |  | 18250 |  |  |  |  | -4629.5
1008811 |  | 153181.54 | 186095 | 80672.5 | 9418.5
1008815 | 323309.4 | 721910.2000000001 | 889588.1599999997 | 179531.33 | 220949.2 | 2050 | 36486.5 | 73261.5 | 68970 | 100650 | 43941.4
1008820 | 3321.53 | 17800.22 | 29259.51 | 10581.65 | 5350.059999999999 | 1039.75 |  | 369.66 | 2951.87
1008814 |  | 585 | 84950 | 116758 | 221
1008822 | 148026.18 | 285537.5699999999 | 430288.6299999999 | 1086385.929999999 | 1356713.230000001 | 284900.42 | 22197.78 | 48456.13 | 34163.83 | 25039.16 | 18169.28
1008826 | 60866.05 | 136883.84 | 74961.79999999996 | 276260.0600000002 | 247355.8 | 71600.56999999998 | 7486.690000000001 |  | 45700.22 | 90.18 | 7588.96
1008816 |  | 115965 | 91445 |  | 27160
1008828 | 4331.280000000001 | 5625.18 | 4018.05 | 3664.97 | 9740.65 | 2207.51 |  | 302.77 | 2356.07 | 1672.44
1008817 |  | 18689 |  |  | 5336.5 | 1150
1008829 | 478.92 | 2819.790000000001 | 1007.76 | 2249.24 | 1213.63 | 444.91 |  | 247.4 |  | 231.52
1008819 |  |  |  | 2385.06 | 14891 | 8967
1008831 | 1114.81 |  |  | 679.77 | 521.32 | 104.61 |  |  | 890 | 0.01999999999998181 | 224.79
1008834 | 3000 | 26092.5 | 193648.75 | 32839 | 3678.45 |  |  |  | -1625 | 4625
1008835 | 38310 |  | 57165 | 110665 | 64680 | 12375 |  | 22230 |  | 16080
1008825 |  |  |  |  | 0
1008837 | 10951.5 | 17383.3 | 3135 |  |  | 0 |  |  | 10951.5
1008849 | 3650 | 19170 | 24300 | 0 | 6800 | 29245 | 3600 | 50
1008827 |  |  |  | 140
1008851 | 78455.4 | 205940.38 | 182978.92 | 111229.12 | 38816.94 | 13493.88 | 18703.7 | 12248 | 16591.7 | 17827 | 13085
1008861 | 544.78 | 525 | 100299 | 42086.82 | 55540 | 31830 | 544.78
1008863 | 12720 | 75455 | 12600 | 2755 | 918.08 |  | 7020 | 1900 |  | 3800
1008830 |  | 562859.4199999999 | 3121607.5 | 373150 | 21896
1008865 | 78734.80000000002 | 140765.4 | 87220.66 | 23465.5 | 66281 | 690 |  | 77294.8 |  |  | 1440
1008867 | 147738.0199999999 | 151964.97 | 143341.96 | 34308.94 | 10306 | 3255 | 1886.7 | 78659.22 | 13717.2 | 49566.8 | 3908.1
1008833 |  | 1430 | -138.8 | 0
1008871 | 2121.6 | 7663.39 | 19031.5 | 18854.5 |  |  | 1521.6 |  |  | 600
1008873 | 1830 |  | 16202.5 | 48811.8 | 5795 | 14900 | 1830
1008875 | 17928.75 | 160050 | 109270 | 164767 | 35934.9 | 21215 | 600 |  |  | 17328.75
1008836 |  | 30
1008878 | 15534 | 21825 | 24176.16 | 650 | 7600 | 856 |  | 540 | 13914 | 540 | 540
1008890 | 1989.44 | 74938.89 | 24475.39 | 5548.02 | 788 |  | 1068.26 |  |  |  | 921.1800000000001
1008838 |  |  |  | -215 | 488532.64
1008901 | 1263.15 | 1336.5 | 48800 | 41200 | 4148.28 |  |  |  | 1263.15
1008839 |  |  | -1.534772309241816e-12 |  | 29998.5
1008909 | 21284.4 | 24016.24 | 77621 | 858.9 | 4615 | 140.65 | 16049 | 3700.4 |  | 1535
1008840 |  | 3390 | 2840 | 1300 | 2475
1008910 | 23057.4 | 74420.73999999999 | 39060 | 8945 | 25650 | 3600 | 1907.4 |  | 21150
1008841 |  | 836 | 730 | 720 | 3090
1008913 | 151032.5 | 137535 | 54018.8 |  | 25616 |  | 146632.5 |  | 2275 | 2125
1008843 |  |  | 103165.44 |  |  | 50733.45
1008914 | -1475 | -687.5 | 687.5 |  | 6896 |  |  |  |  | -1475
1008844 |  |  |  |  | 3990.88 | 145.5
1008916 | 38094 |  |  | 116780.8 | 67830 | 377375 |  |  |  | 38094
1008845 |  |  |  |  | 4510 | 13930
1008918 | 4367 |  |  |  |  |  |  | 4367
1008846 |  |  |  |  | 43812.15 | 13202.2
1008848 |  |  |  | 13820 | 10135
1008850 |  |  | 550 |  | 6785
1008853 |  | -2345 |  | 1775.17 | 675
1008856 |  | -44885.5 | 37468.5
1008857 |  | 115524.85 | 90734.36 | 41719.98 | 85784.80000000002
1008858 |  |  |  | 28255.75 | 35004 | 16294
1008862 |  | 441451.5 | 965850 | 52060
1008864 |  | 6057.7 |  | 5120
1008868 |  | 0 | 78020 | 298909.35 | 150025
1008869 |  |  | 6745 | 104890 | 4600
1008872 |  | -10750 | 22870 | 16220 | 2540 | 132080
1008874 |  |  |  | 390
1008877 |  |  |  |  | 250
1008885 |  | 0 | 45414.72000000001 | 44074.4 | 24830 | 7754.5
1008887 |  | 32000 | 1535855 | 737313.2 | 841325 | 40606
1008897 |  |  | 88810 | 103790
1008904 |  | 26857.25 | 5550 | 993.8699999999999 | 480
1008911 |  | 4350 |  | 35330 | 12187.6 | 6275
1008912 |  | 29035 | 1225
1008915 |  | 6700 |  | 0 | 148928.5 | 8610
1008917 |  |  |  | 13160 | 77190
1008920 |  |  |  | 338316.44 | 935651.97 | 31980
1008928 |  |  |  |  |  | 930
1008949 |  |  |  |  |  | 1335
1008955 |  |  |  |  | 43.36 | 322.6
1008967 |  | 7161 | 44350 | 600 | 442 | 1200
1008969 |  |  |  |  |  | 5100
1008991 |  | 0 | 97532.01 | 832397.9099999999 | 79291.06999999999
1009038 | 13241.36 |  |  | 63790.7 | 63790.7 | 66790.7 |  |  | 12966.36 |  | 275
1009049 | 184635 |  | 46595 | 56271.38 | 149496.23 |  |  |  | 184635
1009070 |  |  | 4053.38 | 8450.01 | 42205.7
1009090 |  |  |  |  | 310
1009102 |  |  |  | 1200 | 11290
1009112 |  |  | 8030.02
1009126 |  | 355.3 | 9550 |  | 1750
1009141 | 4950 | 30703.5 | 3250 |  |  |  | 4950 |  | 1625 | -1625 | 0
1009199 |  |  |  |  | 1195
1009209 |  |  |  |  | 940
1009239 |  | 45366 | 20250 | 31116.5 | 15175.5
1009274 |  | 377892.84 |  |  | 89052.34
1009335 |  |  |  |  | 310
1009343 |  |  |  |  | 0
1009350 |  | 80 |  | 575.63 | 2749.71
1009368 |  | 799.4 |  | 1407.07 | 375.71
1009370 |  |  |  |  | 3746.7
1009396 |  |  |  |  | 190
1009523 |  |  |  |  | 11475
1009551 |  |  | 3545 |  | 8920
1009567 |  |  |  |  | 925
1009583 |  |  |  |  | 187.66
1009601 |  |  |  | 380
1009644 |  |  |  |  | 310
1009658 |  | 99286.20999999999 | 115023.06 | 151680.0499999999 | 21614.51
1009665 |  |  | 7175 | 2750 | 2550
1009692 |  |  |  | 4145.4 | 5586.389999999999
1009698 |  | 48605 | 3880 | 75090 | 19100
1009725 | 10858.86 | 9896 | 11448.57 | 15207 | 5033.030000000001 |  |  | 5530.97 |  | 5327.889999999999
1009730 |  | -2921.2 | 2921.2
1009735 |  |  |  |  | 750
1009790 | 1288 | 690.03 | 1223.56 | 1783.51 |  |  |  |  |  |  | 1288
1009793 |  |  | 6650 | 7725
1009804 | 2020 | -442.49 | 1005 | 365 |  |  |  |  |  | 2020
1009814 | 18583.4 | 16994 | 30885 | 24227.36 |  |  |  |  |  |  | 18583.4
1009817 |  | 1125 | 6995 | 3285
1009844 |  |  |  | 0
1009864 |  |  |  | 1166.25
1009879 |  |  |  | 855.07
1009884 |  |  |  | 785
1009885 |  |  |  | 36631.98
1009922 |  | 151280.82 | 223743.28 | 0
1009944 | 9812.25 | 63169 |  | 21900 |  |  |  |  |  | 9812.25
1009945 | 60238.3 | 75640.55999999998 | 86444.41 | 50840.69 |  |  | 12003.2 | 4691.5 | 41431.59999999999 | 2112
1009973 |  |  |  | 0
1009979 |  | 259.38 |  | 266.54
1009980 | 80 | 4618.35 | 80 |  |  |  | 80
1010002 |  |  |  | 3285
1010038 | 539.73 | 19103.17 | 28899.36 |  |  |  |  | 592.2 | -52.47
1010044 |  |  |  | 0
1010058 |  |  | 200 | 21721.9
1010060 |  |  |  | 2190
1010074 |  |  |  | 2720
1010080 |  |  | 19500 | 86187.69
1010081 |  |  | 161.56 | 0
1010115 |  | 3008.5 |  | 0
1010140 |  |  |  | 390
1010143 | -959.98 | 99775 | 78456.75 | 2055 |  |  |  |  |  |  | -959.98
1010181 | -150 | 26892 | 92064.5 | 84237.5 |  |  | -150
1010203 |  |  |  | 130
1010222 |  |  |  | 131.16
1010240 |  |  | -570.22 | 0
1010244 |  |  | 525 | 1780
1010252 |  |  | 34110 | 6630
1010314 | 5325 | 3020 | 17615 | 24000 |  |  | 1260 | 540 | 600 | 2475 | 450
1010327 | -1650 |  | 16332 | 7875 |  |  |  |  |  | -1650
1010385 |  | -158.13 | 637.61
1010386 | -600 | 18720 | 3400 |  |  |  |  |  | -800 | 200
1010390 |  |  | 890
1010391 |  | -199.14 | 705
1010392 |  | -148.44 | 1710
1010393 |  |  | 656.56
1010394 |  |  | 1767.81
1010434 |  | 37536.78 | 2818.74
1010441 |  |  | 62699
1010444 |  | 1704 | 1680
1010450 |  |  | 620
1010455 |  | 14410 | 24050
1010498 |  |  | 4380
1010568 |  | -2341.3 | 3190.960000000001
1010665 | 5130 | 10241 | 8181 |  |  |  | 990 |  | 3150 |  | 990
1010674 |  |  | 857.7800000000001
1010684 |  |  | 645
1010690 |  |  | 190
1010709 |  |  | 210
1010737 |  |  | 790
1010742 |  |  | 995
1010746 |  | 705 | 3810
1010767 |  |  | 1185
1010768 | 10012.2 | 12124.12 | 9580 |  |  |  |  |  |  | 10012.2
1010781 |  |  | 0
1010817 |  | 0 | -17250.00000000003
1010856 |  |  | 890
1010865 |  |  | 4120
1010888 | 1546 | 8465 | 1140 |  |  |  | 726 |  |  | 820
1010939 |  | 16293.24
1010986 |  | 105.6 | 790
1010998 |  | 15219.8 | 1208
1011038 |  | 3970
1011049 |  | 0
1011050 | 540 | 4222.5 |  |  |  |  |  |  |  | 540
1011110 |  | 12440
1011115 |  | 1205
1011126 |  | 4400
1011262 |  | 434.5
1011264 |  | 2252.8
1011300 | 97323.33 |  |  |  |  |  |  |  | 97323.33
1011313 |  | 1661
1011347 |  | 3070.1
1011348 | 5334.4 | 4900.5 |  |  |  |  | 2362.8 | 787.6 |  |  | 2184
1011425 | 442.04 | 484 |  |  |  |  |  |  | 442.04
1011432 | 2871 |  |  |  |  |  | 1782 | 726 | 363
1011439 | 3170 | 13000 |  |  |  |  | 1740 | 1430
1011442 |  | 429
1011461 |  | 2428.21
1011463 | 625.0500000000001 |  |  |  |  |  | 416.7 |  | 208.35
1011466 | -430 | 5200 |  |  |  |  | -3400 |  | 1770 | 600 | 600
1011539 | 836 |  |  |  |  |  |  | 418 |  | 418
1011542 |  | 363
1011546 | 316050 |  |  |  |  |  |  |  | 316050
1011547 |  | 414.7
1011548 |  | 3558.5
1011555 | 382.8 |  |  |  |  |  | 382.8
1011557 | 385 |  |  |  |  |  | 385
1011565 | 2679.6 |  |  |  |  |  |  | 2679.6
1011578 | 8366.6 |  |  |  |  |  |  | 8366.6
1011585 | 4900 |  |  |  |  |  |  |  | 4900
1011586 | 600 |  |  |  |  |  | 600
1011590 | 32189.64 |  |  |  |  |  |  |  |  |  | 32189.64
1011596 | 1700 |  |  |  |  |  |  |  |  |  | 1700
1011602 | 674.07 |  |  |  |  |  |  |  |  | 674.07
1011635 | 138.6 |  |  |  |  |  |  |  | 138.6
1011703 | 282 |  |  |  |  |  |  |  |  |  | 282