how to show text of same id's in one row

[Arun Kurmi]

There are only two colums. first one is Name and second is id. For an id may be varios name for ex id 1 is for arun and vivek but my sheet have this in two row . i want result in one row

 

[Arun Kurmi]

h[

 

[Peter_SSs]

Try this. (You may need to confirm with Ctrl+Shift+Enter with your excel version)

24 08 14.xlsm
	A	B	C	D	E
1
2		id
3	Name 1	1		1	Name 1, Name 2, Name 3
4	Name 2	1		2	Name 4
5	Name 3	1		3	Name 5, Name 6, Name 7
6	Name 4	2		4	Name 8, Name 9
7	Name 5	3		5	Name 10
8	Name 6	3
9	Name 7	3
10	Name 8	4
11	Name 9	4
12	Name 10	5
IDs

Cell Formulas
Range	Formula
D3:D12	D3	=IFERROR(INDEX($B$3:$B$100,MATCH(0,INDEX(COUNTIF($D$2:D2,$B$3:$B$100)+(B$3:B$101=""),0),0)),"")
E3:E12	E3	=IF(D3="","",TEXTJOIN(", ",,IF(B3:B1100=D3,A3:A100,"")))