Spreadsheet: 720124d1614022513-combine-multiple-rows-into-one-combine-rows-formul-2-2021
Sheet: Sheet1

Merge data from the Rate Change row with the next in sequence, by Start Date
Employee | Emp ID | Performance Code | Start Date | End Date | Cost Ctr# | Shift | Position
[NAME], Mary | 60616 | Quit-Personal Reasons | 2020-09-28 00:00:00 | 2020-10-10 00:00:00 | 2455 | 1st Shift | Assembly
[NAME], Mary | 60616 | Rate Change | 2020-10-26 00:00:00 | 2020-11-29 00:00:00 | 2455 | 1st Shift | Assembly
[NAME], Mary | 60616 | Hired Permanent | 2020-11-30 00:00:00 | 2021-01-09 00:00:00 | 2455 | 1st Shift | Assembly
Smith, [NAME] | 206815 | Rate Change | 2019-03-11 00:00:00 | 2019-06-15 00:00:00 | 2350 | 1st Shift | Assembly
Smith, [NAME] | 206815 | Customer Cancelled | 2019-03-18 00:00:00 | 2019-03-18 00:00:00 | 2350 | 3rd Shift | Assembly
Smith, [NAME] | 206815 | Terminated - Attendance | 2019-06-16 00:00:00 | 2020-01-24 00:00:00 | 2350 | 1st Shift | Assembly
Adams, [NAME] | 117798 | Terminated-Performance | 2019-11-04 00:00:00 | 2019-11-12 00:00:00 | 2300 | 1st Shift | Assembly
[NAME], [NAME] | 39914 | COVID19 Ended | 2020-03-09 00:00:00 | 2020-03-27 00:00:00 | 6500 | 1st Shift | Material Control
Broward, [NAME] | 239778 | Complete | 2020-06-08 00:00:00 | 2020-07-31 00:00:00 | 2080 | 1st Shift | Assembly
Broward, [NAME] | 239778 | Complete | 2019-10-21 00:00:00 | 2020-01-19 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | COVID19 Ended | 2020-01-20 00:00:00 | 2020-03-23 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | [NAME] off worker | 2020-04-14 00:00:00 | 2020-05-29 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | Rate Change | 2020-11-16 00:00:00 | 2020-11-29 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | Assigned | 2020-11-30 00:00:00 |  | 2455 | 1st Shift | Assembly
Helfrich, [NAME] | 368573 | Assigned | 2021-02-01 00:00:00 |  | 2300 | 1st Shift | Assembly
[NAME], [NAME] | 169111 | Rate Change | 2019-04-15 00:00:00 | 2019-07-14 00:00:00 | 2300 | 3rd Shift | Assembly
[NAME], [NAME] | 169111 | [NAME] off worker | 2019-07-15 00:00:00 | 2019-09-26 00:00:00 | 2300 | 3rd Shift | Assembly
[NAME], [NAME] | 169111 | Hired Permanent | 2019-11-03 00:00:00 | 2020-01-23 00:00:00 | 2300 | 3rd Shift | Assembly
Allen, Byron | 58860 | Hired Permanent | 2020-12-02 00:00:00 | 2021-02-13 00:00:00 | 2300 | 1st Shift | Assembly
Columns A, B, F, G & H must ALL match exactly & they'll remain unchanged once rows are merged
Employee | Emp ID | Performance Code | Start Date | End Date | Cost Ctr# | Shift | Position
[NAME], Mary | 60616 | Quit-Personal Reasons | 2020-09-28 00:00:00 | 2020-10-10 00:00:00 | 2455 | 1st Shift | Assembly
[NAME], Mary | 60616 | Hired Permanent | 2020-10-26 00:00:00 | 2021-01-09 00:00:00 | 2455 | 1st Shift | Assembly
Smith, [NAME] | 206815 | Customer Cancelled | 2019-03-18 00:00:00 | 2019-03-18 00:00:00 | 2350 | 3rd Shift | Assembly
Smith, [NAME] | 206815 | Terminated - Attendance | 2019-03-11 00:00:00 | 2020-01-24 00:00:00 | 2350 | 1st Shift | Assembly
Adams, [NAME] | 117798 | Terminated-Performance | 2019-11-04 00:00:00 | 2019-11-12 00:00:00 | 2300 | 1st Shift | Assembly
[NAME], [NAME] | 39914 | COVID19 Ended | 2020-03-09 00:00:00 | 2020-03-27 00:00:00 | 6500 | 1st Shift | Material Control
Broward, [NAME] | 239778 | Complete | 2020-06-08 00:00:00 | 2020-07-31 00:00:00 | 2080 | 1st Shift | Assembly
Broward, [NAME] | 239778 | Complete | 2019-10-21 00:00:00 | 2020-01-19 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | COVID19 Ended | 2020-01-20 00:00:00 | 2020-03-23 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | [NAME] off worker | 2020-04-14 00:00:00 | 2020-05-29 00:00:00 | 2455 | 1st Shift | Assembly
Broward, [NAME] | 239778 | Assigned | 2020-11-16 00:00:00 |  | 2455 | 1st Shift | Assembly
Helfrich, [NAME] | 368573 | Assigned | 2021-02-01 00:00:00 |  | 2300 | 1st Shift | Assembly
[NAME], [NAME] | 169111 | Rate Change | 2019-04-15 00:00:00 | 2019-07-14 00:00:00 | 2300 | 3rd Shift | Assembly
[NAME], [NAME] | 169111 | [NAME] off worker | 2019-07-15 00:00:00 | 2019-09-26 00:00:00 | 2300 | 3rd Shift | Assembly
[NAME], [NAME] | 169111 | Hired Permanent | 2019-11-03 00:00:00 | 2020-01-23 00:00:00 | 2300 | 3rd Shift | Assembly
Allen, Byron | 58860 | Hired Permanent | 2020-12-02 00:00:00 | 2021-02-13 00:00:00 | 2300 | 1st Shift | Assembly