Time off from List to Timeline

Dear Community, here is the case:

I just inherited a team of 15 people who are used to input their time off in an excel sheet with 3 columns: Name, Start Date, End Date. My idea is to create a Timeline from that. The issue I'm having is that a user can have more than one record for time offs.

I've found a couple of formulas online for the timeline. The problem I'm having is that names repeat multiple times in the time off sheet. For example someone can have a couple of day offs in June and some more in July.

So, my idea is to have a timeline with unique names and all days off for that person.

I've attached what I have so far.