Spreadsheet: 802393d1666821261-keeping-rows-in-line-with-date-time-example2-1-
Sheet: Sheet1

1999-08-10 23:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 360 | 7 | 360 | 11 | 2226 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-10 23:04:00
1999-08-11 00:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 350 | 6 | 360 | 10 | 2251 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 00:03:00
1999-08-11 01:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 340 | 6 | 350 | 10 | 46 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 01:04:00
1999-08-11 02:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 350 | 6 | 340 | 9 | 51 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 02:07:00
1999-08-11 03:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 340 | 4 | 340 | 7 | 230 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 03:09:00
1999-08-11 05:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 320 | 3 | 320 | 6 | 421 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 05:06:00
1999-08-11 06:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 330 | 3 | 360 | 6 | 547 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 06:12:00
1999-08-11 08:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 5 | 20 | 8 | 740 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 08:18:00
1999-08-11 09:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 4 | 10 | 7 | 804 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 09:07:00
1999-08-11 10:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 2 | 360 | 6 | 858 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 10:03:00
1999-08-11 11:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 30 | 1 | 40 | 5 | 959 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 11:50:00
1999-08-11 12:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 80 | 1 | 130 | 6 | 1150 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 12:03:00
1999-08-11 13:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 130 | 6 | 150 | 11 | 1230 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 13:02:00
1999-08-11 14:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 140 | 7 | 130 | 11 | 1347 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 14:03:00
1999-08-11 15:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 130 | 7 | 140 | 11 | 1400 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 15:03:00
Required result below:
1999-08-10 23:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 360 | 7 | 360 | 11 | 2226 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-10 23:04:00
1999-08-11 00:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 350 | 6 | 360 | 10 | 2251 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 00:03:00
1999-08-11 01:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 340 | 6 | 350 | 10 | 46 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 01:04:00
1999-08-11 02:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 350 | 6 | 340 | 9 | 51 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 02:07:00
1999-08-11 03:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 340 | 4 | 340 | 7 | 230 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 03:09:00
1999-08-11 05:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 320 | 3 | 320 | 6 | 421 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 05:06:00
1999-08-11 06:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 330 | 3 | 360 | 6 | 547 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 06:12:00
1999-08-11 08:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 5 | 20 | 8 | 740 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 08:18:00
1999-08-11 09:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 4 | 10 | 7 | 804 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 09:07:00
1999-08-11 10:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 2 | 360 | 6 | 858 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 10:03:00
1999-08-11 11:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 30 | 1 | 40 | 5 | 959 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 11:50:00
1999-08-11 12:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 80 | 1 | 130 | 6 | 1150 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 12:03:00
1999-08-11 13:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 130 | 6 | 150 | 11 | 1230 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 13:02:00
1999-08-11 14:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 140 | 7 | 130 | 11 | 1347 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 14:03:00
1999-08-11 15:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 130 | 7 | 140 | 11 | 1400 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 15:03:00
Result new formula
 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 360 | 7 | 360 | 11 | 2226 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-10 23:04:00
1999-08-11 00:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 350 | 6 | 360 | 10 | 2251 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 00:03:00
1999-08-11 01:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 340 | 6 | 350 | 10 | 46 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 01:04:00
1999-08-11 02:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 350 | 6 | 340 | 9 | 51 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 02:07:00
1999-08-11 03:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 340 | 4 | 340 | 7 | 230 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 03:09:00
1999-08-11 05:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 320 | 3 | 320 | 6 | 421 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 05:06:00
1999-08-11 06:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 330 | 3 | 360 | 6 | 547 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 06:12:00
1999-08-11 08:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 5 | 20 | 8 | 740 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 08:18:00
1999-08-11 09:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 4 | 10 | 7 | 804 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 09:07:00
1999-08-11 10:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 10 | 2 | 360 | 6 | 858 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 10:03:00
1999-08-11 11:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 30 | 1 | 40 | 5 | 959 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 11:50:00
1999-08-11 12:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 80 | 1 | 130 | 6 | 1150 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 12:03:00
1999-08-11 13:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 130 | 6 | 150 | 11 | 1230 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 13:02:00
1999-08-11 14:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 140 | 7 | 130 | 11 | 1347 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 14:03:00
1999-08-11 15:00:00 | WIND | 367201 | 1 | HCM | 1 | 498 | 1011 | 130 | 7 | 140 | 11 | 1400 | 6 | 6 | 6 | 6 | 6 | NA | NA | NA | NA | 1999-08-11 15:03:00