To keep it a bit more simple, let's just stick with Graham
name shift_type sunday_shift_date
Graham Late 22/10/2017
Graham Late 29/10/2017
Graham Late 05/11/2017
Graham Morning 12/11/2017
Graham Afternoon 19/11/2017
Graham Afternoon 26/11/2017
Graham Afternoon 03/12/2017
Graham Late 10/12/2017
Graham Late 17/12/2017
--Expected
name Shift From To
Graham Late 22/10/2017 05/11/2017
Graham Morning 12/11/2017 12/11/2017
Graham Afternoon 19/11/2017 03/12/2017
Graham Late 10/12/2017 17/12/2017