Spreadsheet: 867795d1714579744-how-to-join-data-sets-with-different-dates-ef-gkv4
Sheet: Sheet1

Cryptophyta Date | Cryptophyta µm3/ml | Pyrrhophyta Date | Pyrrhophyta µm3/ml | Euglenophyta Date | Euglenophyta µm3/ml |  | Date | Cryptophyta µm3/ml | Pyrrhophyta µm3/ml | Euglenophyta µm3/ml
2015-01-14 00:00:00 | 34946.316 | 2015-01-14 00:00:00 |  | 2015-01-14 00:00:00 | 5142.273333333334 |  | 2015-01-14 00:00:00 | 34946.316 |  | 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-02-11 00:00:00 | 656526.9 |  | 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-03-11 00:00:00 | 42455.03759398496 | 2373.684210526316 | 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-04-14 00:00:00 | 204505.1724137931
2015-05-12 00:00:00 | 57985.71428571428 | 2015-06-09 00:00:00 | 3205.07614213198 | 2015-07-07 00:00:00 |  |  | 2015-05-12 00:00:00 | 57985.71428571428 | 4026.785714285714
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-05-26 00:00:00 | 132115.5 | 180000 | 9198.106666666667
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-09 00:00:00 | 37362.03045685279 | 3205.07614213198
2015-06-23 00:00:00 | 76890.75 | 2015-07-21 00:00:00 | 420000 | 2015-08-31 00:00:00 | 34005.4 |  | 2015-06-23 00:00:00 | 76890.75 | 2209235.2
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-07 00:00:00 | 20837.04 | 4800000
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-07-21 00:00:00 | 37821.3 | 420000 | 5142.273333333334
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-04 00:00:00 | 271456.0961154339 |  | 154040.458052531
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-18 00:00:00 | 76225.66365633946 | 5889006.772848962
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-28 00:00:00 | 65060.22408963586 | 11053.92156862745
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-08-31 00:00:00 | 40409.6 | 353584 | 34005.4
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-03 00:00:00 | 37462.55048157433 | 407949.486577201
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-09-15 00:00:00 | 110359.712420986 | 1582457.91872502
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-10-13 00:00:00 | 98540.41095890412
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-11-10 00:00:00 | 42351.97132616486
2015-12-15 00:00:00 | 37300.75187969924 | 2017-08-15 00:00:00 | 108754.9212598425 | 2022-01-10 00:00:00 | 14607.13058419244 |  | 2015-12-15 00:00:00 | 37300.75187969924
 |  |  |  |  |  |  | 2016-04-12 00:00:00 |  |  | 34361.90476190476
 |  |  |  |  |  |  | 2016-07-05 00:00:00 |  | 204620.3703703704
 |  |  |  |  |  |  | 2016-09-13 00:00:00 |  | 242313.5964912281
 |  |  |  |  |  |  | 2016-11-15 00:00:00 |  | 4599.358974358975
 |  |  |  |  |  |  | 2017-07-18 00:00:00 |  | 207697.3684210526
 |  |  |  |  |  |  | 2017-08-01 00:00:00 |  | 242313.5964912281
 |  |  |  |  |  |  | 2017-08-15 00:00:00 |  | 108754.9212598425 | 20918.67618110236
 |  |  |  |  |  |  | 2017-10-13 00:00:00 |  |  | 30536.45833333334
 |  |  |  |  |  |  | 2018-05-29 00:00:00 |  |  | 10342.27493917275
 |  |  |  |  |  |  | 2018-11-13 00:00:00 |  |  | 24644.8087431694
 |  |  |  |  |  |  | 2020-05-19 00:00:00 |  |  | 6269.43215339233
 |  |  |  |  |  |  | 2020-06-29 00:00:00 |  |  | 12501.98529411765
 |  |  |  |  |  |  | 2020-11-09 00:00:00 |  |  | 21910.69587628866
 |  |  |  |  |  |  | 2021-03-08 00:00:00 |  |  | 14283.18212365591
 |  |  |  |  |  |  | 2021-07-06 00:00:00 |  |  | 16348.75
 |  |  |  |  |  |  | 2022-01-10 00:00:00 |  |  | 14607.13058419244