Merge consecutive time intervals

Hi everyone,

I'm trying to merge some rows of a table based on consecutive time intervals. My table looks something like this:

I would like to merge the rows within each block of similar values in the "value" column, so that the result looks like:

A simple 

GROUPBY(table, [Value], "Start Date Merged", MINX(CURRENTGROUP(), [Start Date]), "End Date Merged", MAXX(CURRENTGROUP(), [End Date]))

 doesn't work because the values in "Value" are not unique outside the blocks I want to merge.

Any help with this would be greatly appreciated, as I have been trying to wrap my head around this for quite some time.

Thanks!