Combine 2 rows that match a unique identifier (first n)

[MROGK]

Can someone help me with this challenge? Looking to combine the 2 rows that have different dates but match on first 11 characters in IP Number.  In the result table, I'd like the min. of the two start dates and max. of end dates and sum of amount & days.  Thank you

Name	Start Date	End Date	Report Days	Sum	IP Number	Move Start Date	Move End Date	Tile Number	Code
XYZ	1/10/2022	1/31/2022	4	$2,000	WO.12.34567.001	1/9/2022	2/1/2022	9	Internal
XYZ	1/11/2022	2/2/2022	5	$3,500	WO.12.34567.002	1/10/2022	2/3/2022	10	External
ABC	1/5/2022	3/31/2022	6	$1,500	DP.34.56789.001	1/6/2022	2/28/2022	3	Internal

LOOKING FOR THIS RESULT

Name	Start Date	End Date	Report Days	Sum	IP Number	Move Start Date	Move End Date	Tile Number	Code
XYZ	1/10/2022	2/2/2022	9	$5,500	WO.12.34567.001	1/9/2022	2/3/2022	9	Internal
ABC	1/5/2022	3/31/2022	6	$1,500	DP.34.56789.001	1/6/2022	2/28/2022	3	Internal

[Matthew]

a summarise tool should be able to do it

[NeilParrott]

@MROGK 

The main line is similar to Matthew's approach; however, this workflow adds a couple other pieces to consider. I always like to see if there is additional info that could be added to help with future considerations.

Note: you could reduce the amount of Date Time Tools by using a transpose prior to the Date Time in order to stack the dates into the "value" column. Then you can use that one column on the dates. A cross tab will then help you revert back to the wider column view.