Spreadsheet: 867732d1714528980-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
2015-01-14 00:00:00 | 34946.316 | 2015-01-14 00:00:00 |  | 2015-01-14 00:00:00 | 5142.273333333334 |  |  |  | 34946.316 |  | 5142.273333333334 | 40088.58933333333
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 | 2373.684210526316 | 20569.09333333333 | 679469.6775438597
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 | 4026.785714285714 | 6391.992481203007 | 52873.81578947368
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 | 180000 | 9198.106666666667 | 393703.2790804598
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 | 3205.07614213198 |  | 61190.79042784626
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 | 2209235.2 | 5142.273333333334 | 2346492.973333334
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 | 4800000 | 154040.458052531 | 4991402.488509384
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 | 420000 | 34005.4 | 530896.15
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 | 5889006.772848962 | 34361.90476190476 | 5944205.717610867
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 | 11053.92156862745 | 20918.67618110236 | 69793.89774972982
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 | 353584 | 30536.45833333334 | 655576.5544487672
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 | 407949.486577201 | 10342.27493917275 | 494517.4251727132
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 | 1582457.91872502 | 24644.8087431694 | 1672162.951557825
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 | 204620.3703703704 | 6269.43215339233 | 251299.4025237627
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 | 242313.5964912281 | 12501.98529411765 | 292278.1322669201
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 | 4599.358974358975 | 21910.69587628866 | 136869.7672716336
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 | 207697.3684210526 | 14283.18212365591 | 320520.9615036127
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 | 242313.5964912281 | 16348.75 | 301014.3178173929
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 | 108754.9212598425 | 14607.13058419244 | 160662.8037237342