This is the data field I am working with for my exercise (for overlap in terms):

171711 - BB - PUK (Source).PNG

The exercise is as follows. PUK has an employee who works on the same project with the same term or who starts/ends during the same kind of project (so that there is overlap in terms of dates). Due to administrative inconvenience (as you might have read), PUK did not register it properly. There are doubles.

How can these doubles be taken out and be shown separately (taking into account the beforementioned terms)?

Example.
The pivot table shows that ID '296377' is working on four projects, which overlap or follow each other up.

171711 - BB - PUK (Doubles).PNG

Projectcode 10620 shows that there is an overlap in terms. I would like to have such an overlap to be shown separately.

171711 - BB - PUK (ID - Doubles).PNG

How do I get this done in Excel?

I am very grateful for your wisdom!