Count of consecutive dates as single occasion per patient

Hi,

I could not comprehend the requirement by going through the excel sheet uploaded by you, my apologies. Can you please insert a desired result tab and mock the output?