Spreadsheet: 867703d1714516953-how-to-join-data-sets-with-different-dates-excelforumexample
Sheet: Sheet1

Cryptophyta Date | Cryptophyta µm3/ml | Pyrrhophyta Date | Pyrrhophyta µm3/ml | Euglenophyta Date | Euglenophyta µm3/ml
2015-01-14 00:00:00 | 34946.316 | 2015-01-14 00:00:00 | 30000 | 2015-01-14 00:00:00 | 5142.273333333334
2015-02-11 00:00:00 | 656526.9 | 2015-03-11 00:00:00 | 2373.684210526316 | 2015-02-11 00:00:00 | 20569.09333333333
2015-03-11 00:00:00 | 42455.03759398496 | 2015-05-12 00:00:00 | 4026.785714285714 | 2015-03-11 00:00:00 | 6391.992481203007
2015-04-14 00:00:00 | 204505.1724137931 | 2015-05-26 00:00:00 | 180000 | 2015-05-26 00:00:00 | 9198.106666666667
2015-05-12 00:00:00 | 57985.71428571428 | 2015-06-09 00:00:00 | 3205.07614213198 | 2015-07-07 00:00:00 | 5142.273333333334
2015-05-26 00:00:00 | 132115.5 | 2015-06-23 00:00:00 | 2209235.2 | 2015-07-21 00:00:00 | 5142.273333333334
2015-06-09 00:00:00 | 37362.03045685279 | 2015-07-07 00:00:00 | 4800000 | 2015-08-04 00:00:00 | 154040.458052531
2015-06-23 00:00:00 | 76890.75 | 2015-07-21 00:00:00 | 420000 | 2015-08-31 00:00:00 | 34005.4
2015-07-07 00:00:00 | 20837.04 | 2015-08-18 00:00:00 | 5889006.772848962 | 2016-04-12 00:00:00 | 34361.90476190476
2015-07-21 00:00:00 | 37821.3 | 2015-08-28 00:00:00 | 11053.92156862745 | 2017-08-15 00:00:00 | 20918.67618110236
2015-08-04 00:00:00 | 271456.0961154339 | 2015-08-31 00:00:00 | 353584 | 2017-10-13 00:00:00 | 30536.45833333334
2015-08-18 00:00:00 | 76225.66365633946 | 2015-09-03 00:00:00 | 407949.486577201 | 2018-05-29 00:00:00 | 10342.27493917275
2015-08-28 00:00:00 | 65060.22408963586 | 2015-09-15 00:00:00 | 1582457.91872502 | 2018-11-13 00:00:00 | 24644.8087431694
2015-08-31 00:00:00 | 40409.6 | 2016-07-05 00:00:00 | 204620.3703703704 | 2020-05-19 00:00:00 | 6269.43215339233
2015-09-03 00:00:00 | 37462.55048157433 | 2016-09-13 00:00:00 | 242313.5964912281 | 2020-06-29 00:00:00 | 12501.98529411765
2015-09-15 00:00:00 | 110359.712420986 | 2016-11-15 00:00:00 | 4599.358974358975 | 2020-11-09 00:00:00 | 21910.69587628866
2015-10-13 00:00:00 | 98540.41095890412 | 2017-07-18 00:00:00 | 207697.3684210526 | 2021-03-08 00:00:00 | 14283.18212365591
2015-11-10 00:00:00 | 42351.97132616486 | 2017-08-01 00:00:00 | 242313.5964912281 | 2021-07-06 00:00:00 | 16348.75
2015-12-15 00:00:00 | 37300.75187969924 | 2017-08-15 00:00:00 | 108754.9212598425 | 2022-01-10 00:00:00 | 14607.13058419244
2016-01-19 00:00:00 | 77608.62944162436 | 2017-08-29 00:00:00 | 138464.9122807017 | 2022-05-10 00:00:00 | 14810.71428571429
2016-02-16 00:00:00 | 587135.1851851852 | 2018-05-29 00:00:00 | 53768.85644768857 | 2022-05-25 00:00:00 | 20626.4435695538
2016-03-15 00:00:00 | 50802.29885057472 | 2018-06-11 00:00:00 | 329835.8208955224
2016-04-12 00:00:00 | 195862.8571428571 | 2018-08-06 00:00:00 | 781804.2452830189
2016-04-26 00:00:00 | 176281.2785388128 | 2019-07-29 00:00:00 | 11692.59259259259
2016-05-10 00:00:00 | 90745.56451612903 | 2019-08-26 00:00:00 | 86730.76923076922
2016-06-21 00:00:00 | 55957.40740740741 | 2020-06-02 00:00:00 | 61815.38461538461
2016-07-05 00:00:00 | 44682.40740740741 | 2021-05-24 00:00:00 | 116310.5263157895
2016-07-19 00:00:00 | 88679.77528089887 | 2021-06-07 00:00:00 | 40623.16176470589
2016-08-02 00:00:00 | 2692.537313432836 | 2021-06-22 00:00:00 | 11380.3738317757
2016-08-16 00:00:00 | 24750 | 2021-08-02 00:00:00 | 192500
2016-08-30 00:00:00 | 53270.28985507246 | 2021-08-17 00:00:00 | 312132.7683615819
2016-09-13 00:00:00 | 114233.5526315789 | 2022-04-11 00:00:00 | 12142.30769230769
2016-10-11 00:00:00 | 82630.76923076923 | 2022-06-06 00:00:00 | 28484.21052631579
2016-11-15 00:00:00 | 37977.56410256409 | 2022-06-21 00:00:00 | 62514.85148514851
2016-12-13 00:00:00 | 182264.5994832041 | 2022-07-06 00:00:00 | 120759.5628415301
2017-01-17 00:00:00 | 123110.8108108108
2017-01-24 00:00:00 | 199567.5
2017-02-14 00:00:00 | 252384.4282238443
2017-03-15 00:00:00 | 309647.619047619
2017-04-11 00:00:00 | 28584.50704225352
2017-05-09 00:00:00 | 144271.5053763441
2017-05-23 00:00:00 | 144033.6507936508
2017-06-06 00:00:00 | 71898.55072463768
2017-06-20 00:00:00 | 160105
2017-07-03 00:00:00 | 81975.24154589372
2017-07-18 00:00:00 | 25856.20300751879
2017-08-01 00:00:00 | 54396.9298245614
2017-08-15 00:00:00 | 29075.29527559055
2017-08-29 00:00:00 | 29671.05263157895
2017-09-12 00:00:00 | 57883.81995133821
2017-09-26 00:00:00 | 84733.33333333333
2017-10-09 00:00:00 | 40976.27314814815
2017-10-13 00:00:00 | 143529.4540229885
2017-12-18 00:00:00 | 11496.07843137255
2018-01-15 00:00:00 | 11581.23456790124
2018-02-12 00:00:00 | 2878.723404255319
2018-03-26 00:00:00 | 73632.6530612245
2018-04-19 00:00:00 | 206130.1282051282
2018-05-14 00:00:00 | 112308.8810641627
2018-05-29 00:00:00 | 50696.3503649635
2018-06-11 00:00:00 | 196891.7910447761
2018-06-25 00:00:00 | 2981.818181818182
2018-07-09 00:00:00 | 81327.86885245903
2018-07-16 00:00:00 | 86799.60317460318
2018-08-06 00:00:00 | 16487.02830188679
2018-08-21 00:00:00 | 37904.55840455841
2018-09-04 00:00:00 | 5228.985507246376
2018-09-17 00:00:00 | 16340.57971014493
2018-10-22 00:00:00 | 119225.5067567567
2018-11-13 00:00:00 | 149101.0928961748
2018-12-11 00:00:00 | 110645.3333333333
2019-01-07 00:00:00 | 39767.22972972973
2019-02-04 00:00:00 | 10760.70175438597
2019-03-04 00:00:00 | 15033.33333333333
2019-04-15 00:00:00 | 18141.72932330827
2019-05-06 00:00:00 | 20758.35616438356
2019-05-23 00:00:00 | 44878.92156862745
2019-06-03 00:00:00 | 76909.66183574879
2019-06-17 00:00:00 | 71537.93103448275
2019-07-02 00:00:00 | 91500.96153846153
2019-07-15 00:00:00 | 41509.95024875622
2019-07-29 00:00:00 | 57627.77777777778
2019-08-12 00:00:00 | 32245.41062801932
2019-08-26 00:00:00 | 27966.2480376766
2019-09-09 00:00:00 | 29083.17757009346
2019-09-23 00:00:00 | 32800
2019-10-07 00:00:00 | 44927.2030651341
2019-11-04 00:00:00 | 104231.1111111111
2019-12-02 00:00:00 | 138367.0740127037
2019-02-10 00:00:00 | 110627.6470588235
2020-03-09 00:00:00 | 42330.70175438597
2020-04-13 00:00:00 | 31570
2020-05-04 00:00:00 | 82105.12820512822
2020-05-19 00:00:00 | 44833.9233038348
2020-06-02 00:00:00 | 48443.07692307692
2020-06-15 00:00:00 | 89985.23809523809
2020-06-29 00:00:00 | 64731.76470588236
2020-07-13 00:00:00 | 55334.23076923077
2020-07-27 00:00:00 | 133315.6
2020-08-10 00:00:00 | 70745.09803921569
2020-08-24 00:00:00 | 53983.33333333334
2020-09-21 00:00:00 | 10222.66666666667
2020-10-12 00:00:00 | 53722.05882352941
2020-11-09 00:00:00 | 381955.1546391753
2020-12-07 00:00:00 | 16063.01369863014
2021-01-11 00:00:00 | 7714.473684210527
2021-02-08 00:00:00 | 70573.14814814815
2021-03-08 00:00:00 | 44857.52688172043
2021-04-12 00:00:00 | 127438.5321100917
2021-05-03 00:00:00 | 63208.33333333333
2021-05-24 00:00:00 | 104849.022556391
2021-06-07 00:00:00 | 75608.82352941176
2021-06-22 00:00:00 | 46701.68224299065
2021-07-06 00:00:00 | 28100.76923076923
2021-07-19 00:00:00 | 138990
2021-08-02 00:00:00 | 19066.66666666667
2021-08-17 00:00:00 | 34716.80790960451
2021-08-30 00:00:00 | 46694.44444444445
2021-09-13 00:00:00 | 59715.74074074074
2021-09-27 00:00:00 | 83207.7519379845
2021-10-11 00:00:00 | 75710.04016064256
2021-11-17 00:00:00 | 15510.58201058201
2021-12-14 00:00:00 | 43087.66404199475
2022-01-10 00:00:00 | 28206.87285223368
2022-02-14 00:00:00 | 62464.08268733849
2022-03-16 00:00:00 | 21320
2022-04-11 00:00:00 | 78404.61538461539
2022-05-10 00:00:00 | 122571.4285714286
2022-05-25 00:00:00 | 86885.56430446195
2022-06-06 00:00:00 | 74194.5864661654
2022-06-21 00:00:00 | 117215.3465346535
2022-07-06 00:00:00 | 100057.9234972678