combining rows

[ntudev]

can someone help me with a code to get the end result below, I just want to combine multiple rows into 1 row.

intial result	end result
1	a	1	a,b,c
1	b	3	e,f,g
1	c	5	I,j
3	e	9	k,l,m
3	f
3	g
5	h
5	i
5	j
9	k
9	l
9	m

[Yoshiro_Fujimori]

Hi @ntudev ,

I think it is a simple use case of Summary tool.

Summary tool configuration

Output

I hope this answers to your question.

[Qiu]

@ntudev 
As suggested by @Yoshiro_Fujimori , I agree that Summarize tool is most straightforward.
and just trying another different way.