Spreadsheet: 771764d1646836065-issues-with-creating-summary-table-distinguishing-months-from-various-years-excel-help-document
Sheet: Data

time | WaveHeight | Gust | SeaTemperature | AirTemperature
UTC | meters | knots | degrees_C | degrees_C |  |  |  |  |  | 1
2007-05-03T09:00:00Z | 1 | NaN | 12.1 | 12.2 |  |  |  |  |  | 1
2007-05-03T10:00:00Z | 1 | NaN | 12.3 | 12.3 |  |  |  |  |  | 0.9
2007-05-03T11:00:00Z | 0.9 | NaN | 12.3 | 12.4 |  |  |  |  |  | NaN
2007-05-03T12:00:00Z | NaN | NaN | 12.4 | 12.3 |  |  |  |  |  | 1
2007-05-03T13:00:00Z | 1 | NaN | 12.5 | 12.3 |  |  |  |  |  | 0.9
2007-05-03T14:00:00Z | 0.9 | NaN | 12.5 | 12 |  |  |  |  |  | 1
2007-05-03T15:00:00Z | 1 | 18 | 12.6 | 10.1 |  |  |  |  |  | 1
2007-05-03T16:00:00Z | 1 | 16 | 12.6 | 10 |  |  |  |  |  | 0.9
2007-05-03T17:00:00Z | 0.9 | 16 | 12.6 | 10.2 |  |  |  |  |  | 0.9
2007-05-03T18:00:00Z | 0.9 | 15 | 12.6 | 10 |  |  |  |  |  | 1
2007-05-03T19:00:00Z | 1 | 16 | 12.6 | 10.1 |  |  |  |  |  | 0.9
2007-05-03T20:00:00Z | 0.9 | 18 | 12.5 | 10.3 |  |  |  |  |  | 0.9
2007-05-03T21:00:00Z | 0.9 | 16 | 12.4 | 10.8
2007-07-14T19:00:00Z | 1.4 | 11 | 15 | 14.8
2007-07-14T20:00:00Z | 1.4 | 10 | 15 | 14.8
2007-07-14T21:00:00Z | 1.5 | 8 | 15 | 14.7
2007-07-14T22:00:00Z | 1.4 | 6 | 15 | 14.5
2007-07-14T23:00:00Z | 1.5 | 6 | 14.9 | 14.4
2007-07-15T00:00:00Z | 1.5 | 8 | 15 | 14.5
2007-07-15T01:00:00Z | 1.3 | 8 | 15 | 14.5
2007-07-15T02:00:00Z | 1.3 | 9 | 14.9 | 14.4
2008-01-16T21:00:00Z | 3.1 | 31 | 10.6 | 9
2008-01-16T22:00:00Z | 3.7 | 34 | 10.6 | 8.3
2008-01-16T23:00:00Z | 3.6 | 31 | 10.6 | 8.4
2008-01-17T00:00:00Z | 3.3 | 31 | 10.6 | 9
2008-01-17T01:00:00Z | 3.4 | 37 | 10.6 | 7.4
2008-01-17T02:00:00Z | 3.6 | 37 | 10.6 | 8.6
2008-01-17T03:00:00Z | 3.7 | 34 | 10.6 | 7.8
2008-01-17T04:00:00Z | 4 | 37 | 10.5 | 9
2008-01-17T05:00:00Z | 3.9 | 40 | 10.5 | 10.4
2008-01-17T06:00:00Z | 4 | 29 | 10.5 | 10.6
2009-06-08T14:00:00Z | 0.8 | NaN | 13 | 12.2
2009-06-08T15:00:00Z | 1.1 | NaN | 13 | 12
2009-06-08T16:00:00Z | 1.2 | NaN | 13.1 | 12
2009-06-08T17:00:00Z | 1.5 | NaN | 13.1 | 12.2
2009-06-08T18:00:00Z | 1.6 | NaN | 13 | 12.2
2009-06-08T19:00:00Z | 1.7 | NaN | 13 | 12.1
2009-06-08T20:00:00Z | 1.7 | NaN | 12.9 | 11.7
2009-06-08T21:00:00Z | 1.6 | NaN | 13 | 12
2009-06-08T22:00:00Z | 1.7 | NaN | 12.9 | 11.9
2009-06-08T23:00:00Z | 1.7 | NaN | 12.9 | 12
2009-06-09T00:00:00Z | 1.7 | NaN | 12.9 | 11.9
2010-01-25T17:00:00Z | 2.5 | NaN | 9.6 | 7.9
2010-01-25T18:00:00Z | 2.5 | NaN | 9.6 | 8
2010-01-25T19:00:00Z | 2.5 | NaN | 9.6 | 8.1
2010-01-25T20:00:00Z | 2.5 | NaN | 9.5 | 8.3
2010-01-25T21:00:00Z | 2.4 | NaN | 9.5 | 8.2
2010-01-25T22:00:00Z | 3.2 | NaN | 9.5 | 8.1
2010-01-25T23:00:00Z | 3 | NaN | 10.1 | 8.3
2010-01-26T00:00:00Z | 3.2 | NaN | 10.2 | 8.3
2010-01-26T01:00:00Z | 3.2 | NaN | 10.2 | 8.5
2011-08-07T14:00:00Z | 0.938 | NaN | 15.142 | 14.038
2011-08-07T15:00:00Z | 0.938 | NaN | 15.21 | 14.106
2011-08-07T16:00:00Z | 1.094 | NaN | 15.21 | 14.277
2011-08-07T17:00:00Z | 1.25 | NaN | 15.176 | 14.243
2011-08-07T18:00:00Z | 1.25 | NaN | 15.176 | 14.346
2011-08-07T19:00:00Z | 1.406 | NaN | 15.073 | 14.141
2011-08-07T20:00:00Z | 1.25 | NaN | 14.971 | 14.004
2011-08-07T21:00:00Z | 1.406 | NaN | 14.868 | 13.97
2013-12-01T20:00:00Z | 3.203 | 13.235 | 11.006 | 11.064
2013-12-01T21:00:00Z | 3.164 | 16.935 | 11.006 | 10.62
2013-12-01T22:00:00Z | 2.891 | 14.8 | 11.006 | 10.176
2013-12-01T23:00:00Z | 2.813 | 19.354 | 11.006 | 10.449
2013-12-02T00:00:00Z | 2.617 | 16.223 | 11.006 | 10.347
2013-12-02T01:00:00Z | 2.578 | 22.912 | 10.972 | 9.39
2013-12-02T02:00:00Z | 2.93 | 20.208 | 10.972 | 9.731
2013-12-02T03:00:00Z | 2.734 | 22.343 | 10.938 | 9.492
2013-12-02T04:00:00Z | 2.5 | 24.904 | 10.972 | 9.561
2013-12-02T05:00:00Z | 2.695 | 23.623 | 10.972 | 9.424
2013-12-02T06:00:00Z | 2.656 | 24.05 | 10.972 | 9.561
2016-10-06T19:00:00Z | 3.164 | NaN | 13.501 | 13.628
2016-10-06T20:00:00Z | 3.203 | NaN | 13.501 | 13.457
2016-10-06T21:00:00Z | 2.891 | NaN | 13.501 | 13.218
2016-10-06T22:00:00Z | 3.203 | NaN | 13.501 | 13.115
2016-10-06T23:00:00Z | 2.695 | NaN | 13.501 | 13.149
2016-10-07T00:00:00Z | 2.578 | NaN | 13.501 | 13.32
2016-10-07T01:00:00Z | 2.578 | NaN | 13.501 | 13.047
2016-10-07T02:00:00Z | 2.5 | NaN | 13.535 | 12.944
2016-10-07T03:00:00Z | 2.539 | NaN | 13.569 | 12.808
2017-05-22T09:00:00Z | NaN | 16.793 | 11.724 | 12.124
2017-05-22T10:00:00Z | NaN | 18.5 | 11.689 | 11.953
2017-05-22T11:00:00Z | NaN | 20.066 | 11.724 | 12.192
2017-05-22T12:00:00Z | NaN | 20.066 | 11.724 | 12.124
2017-05-22T13:00:00Z | NaN | 21.204 | 11.758 | 12.192
2017-05-22T14:00:00Z | NaN | 21.204 | 11.758 | 12.158
2018-02-02T01:00:00Z | NaN | 22.627 | 10.151 | 7.715
2018-02-02T02:00:00Z | NaN | 22.77 | 10.117 | 7.817
2018-02-02T03:00:00Z | NaN | 20.208 | 10.151 | 7.749
2018-02-02T04:00:00Z | NaN | 17.789 | 10.151 | 7.852
2018-02-02T05:00:00Z | NaN | 15.796 | 10.151 | 7.681
2018-02-02T06:00:00Z | NaN | 17.362 | 10.151 | 7.578
2018-02-02T07:00:00Z | NaN | 12.096 | 10.117 | 7.578
2018-02-02T08:00:00Z | NaN | 10.531 | 10.151 | 7.51
2018-03-29T08:00:00Z | NaN | 23.196 | 9.639 | NaN
2018-03-29T09:00:00Z | NaN | 21.916 | 9.639 | NaN
2018-03-29T10:00:00Z | NaN | 20.777 | 9.604 | NaN
2018-03-29T11:00:00Z | NaN | 21.916 | 9.639 | NaN
2018-03-29T12:00:00Z | NaN | 20.777 | 9.639 | NaN
2018-03-29T13:00:00Z | NaN | 20.35 | 9.639 | NaN
2018-03-29T14:00:00Z | NaN | 19.069 | 9.673 | NaN
2018-03-29T15:00:00Z | NaN | 20.92 | 9.639 | NaN
2018-03-29T16:00:00Z | NaN | 18.216 | 9.673 | NaN
2018-04-02T08:00:00Z | NaN | 36.147 | 9.365 | NaN
2018-04-02T09:00:00Z | NaN | 35.72 | 9.365 | NaN
2018-04-02T10:00:00Z | NaN | 38.424 | 9.399 | NaN
2018-04-02T11:00:00Z | NaN | 42.835 | 9.399 | NaN
2018-04-02T12:00:00Z | NaN | 38.708 | 9.434 | NaN
2018-04-02T13:00:00Z | NaN | 43.831 | 9.399 | NaN
2018-04-02T14:00:00Z | NaN | 41.27 | 9.399 | NaN
2018-04-02T15:00:00Z | NaN | 37.143 | 9.468 | NaN
2018-09-28T05:00:00Z | 2.188 | 12.239 | NaN | 11.406
2018-09-28T06:00:00Z | 2.188 | 12.95 | NaN | 11.167
2018-09-28T07:00:00Z | 2.188 | 11.527 | NaN | 11.064
2018-09-28T08:00:00Z | 2.188 | 9.25 | NaN | 11.064
2018-09-28T09:00:00Z | 2.188 | 15.085 | NaN | 10.859
2018-09-28T10:00:00Z | 2.031 | 9.962 | NaN | 11.201
2018-09-28T12:00:00Z | 1.875 | 12.808 | NaN | 11.03
2018-09-28T13:00:00Z | 1.875 | 10.104 | NaN | 11.03
2018-10-01T14:00:00Z | 2.969 | 29.6 | NaN | 12.363
2018-10-01T15:00:00Z | 2.969 | 32.589 | NaN | 12.329
2018-10-01T16:00:00Z | 3.125 | 29.031 | NaN | 12.637
2018-10-01T19:00:00Z | 3.438 | 27.466 | NaN | 13.32
2018-10-01T20:00:00Z | 3.281 | 26.043 | NaN | 13.218
2018-10-01T21:00:00Z | 3.438 | 22.912 | NaN | 12.91
2018-10-01T22:00:00Z | 3.281 | 22.912 | NaN | 12.739
2018-10-01T23:00:00Z | 3.125 | 24.193 | NaN | 12.5
2018-10-02T00:00:00Z | 3.281 | 24.193 | NaN | 12.329