Duplicate record how to change to one?

[lingping]

I want to prepare the excel file, Each person should only have one record, The start date is 2023-08-28 ,and date is 2023-08-30.

But in my excel, Some people have two records, One row start date from 2023-08-28 and end date is 2023-08-29 , the other row start date is 2023-08-30 and end date is 2023-08-30,  How can I remove the duplicate record (Stat date is 2023-08-30)  and change the one end date  from 2023-08-29 to 2023-08-30, Which function can i use to solve this problem?Thanks

Staff Name	Start Date	End Date	Run
Lily Ya	2023-08-28	2023-08-29	Class1	Change this end date to the below one
Lily Ya	2023-08-30	2023-08-30	Class1	Remove this row
Sofa Huang	2023-08-28	2023-08-30	Class1

[Qiu]

@lingping 
It will be better if we can have some sample input and output.

But I assume the logic here is to take minimum Start Date and Max End Date for each persona?
Then Summarize Tool is what should be looking at.

[caltang]

@lingping it was quite hard for me to find the red highlight, but I think your question left it out haha.

@Qiu's Summarize Tool should do the trick, Min Max is dynamic.