Time between period for each ID

[Tommy23]

Hello I would like to have column that tell me if there is one period that are combine for each ID. (Juxtapose period)

Here a example of sample data ( this just an example , how to do it o it can work for various case)

ID	Begin Date	End date
1	28/01/2022	01/02/2022
1	01/01/2022	10/01/2022
2	05/01/2022	18/01/2022
3	19/02/2022	20/02/2022
4	18/01/2022	19/01/2022
4	06/01.2022	07/01/2022
4	02/03/2022	03/03/2022
1	25/01/2022	18/03/2022
2	06/01/2022	07/01/2022
3	14/01/2022	15/01/2022

For example here the ID 1 and 2 have period that are combine 

I hope I was clear thanks

Thanks :)

[IraWatt · Accepted solution]

AAAhhh I think I get it @Tommy23. I adjusted my workflow which does seem to get your result: