Combine two rows which have the same first N characters same

[MROGK]

Hi,

Can someone help me with this challenge in combing the two rows that have the same first 11 characters (identifier) in IP Number? I'm looking to create a single row in the output that gives me Min. Start Date and Max. End Date from the 2 rows. The sum & days will be cumulative. I posted the desired result table below

Student Name	DM Start Date	DM End Date	# of days	Sum	IP Number	Base Start Date	Base End Date	Tag	Code
XYZ	1/1/2022	1/31/2022	4	$3,500	WO.12.34567.001	1/4/2022	2/2/2022	8	Internal
XYZ	12/31/2021	2/1/2022	5	$1,500	WO.12.34567.002	1/2/2022	1/31/2022	9	External
ABC	1/5/2022	3/1/2022	6	$1,500	DP.34.34567.001	1/4/2022	2/28/2022	13	Internal
DBC	2/14/2022	3/6/2022	3	$2,500	WO.45.45634.001	2/14/2022	3/5/2022	15	External

LOOKING FOR THE BELOW OUTPUT

Student Name	DM Start Date	DM End Date	# of days	Sum	IP Number	Base Start Date	Base End Date	Tag	Code
XYZ	12/31/2022	2/1/2022	9	$5,000	WO.12.34567.001	1/2/2022	2/2/2022	8	Internal
ABC	1/5/2022	3/1/2022	6	$1,500	DP.34.34567.001	1/4/2022	2/28/2022	13	Internal
DBC	2/14/2022	3/6/2022	3	$2,500	WO.45.45634.001	2/14/2022	3/5/2022	15	External

[Matthew]

it's certainly doable, i imagine a summarise tool will get you 90% of the way there.

group by Left( [IP Number] ,11 )

[Qiu]

@MROGK 

I also use the Group in the Summarize Tool.
We need to do some date cleasing, such as the format of Sum, the format for Date.

At the last, you can revert the format back if you prefer.