Hi Community.
I am having a challenge with my source data where I would be more than happy about a swift solution.
I get informaton with the following information:
LeadID | Lead | Status | Start Date | End Date
123 | Test | Open | 20.01.2022 | 20.01.2022
123 | Test | Qual | 20.01.2022 | 25.01.2022
123 | Test | Qual | 25.01.2022 | 25.01.2022
123 | Test | Conv | 25.01.2022 | 30.01.2022
What I need to analyze and merge it to my Master Calendar is the following structure
LeadID | Lead | Status | Start Date | End Date
123 | Test | Open | 20.01.2022 | 20.01.2022 (This line will be deleted) as duplicate
123 | Test | Qual | 20.01.2022 | 24.01.2022 (End Date Adjusted from 25.01.2022 to 24.01.2022
123 | Test | Qual | 25.01.2022 | 25.01.2022 This line will be deleted) as duplicate
123 | Test | Conv | 25.01.2022 | 30.01.2022
My Status can have a value to show only the ones with the highest value in case of overlaps, like with 1st line where Status = "Open"
