How to group multiple values with same identifier

[Excellin T]

Hello, First time post, and I haven't been able to find an answer to this anywhere!

I have two columns of data. First column contains a unique identifier, second column contains components of the first column. Each component is listed separately, but I would like to get a list where it shows every component for a unique identifier in the same row. See example below for a better description. I don't even need the commas in the end result (although it would be nice). I've played with everything from pivot tables to vlookups, but I still just can't quite get it. I know how to get a unique list from the unique identifiers in the first column (Box1, Box2), so I can take care of that.... I'm just struggling with how to match the data in the second column to the unique identifiers in the first column, on one row. Thanks SO much in advance for any help you can offer!

DATA
Box1 A
Box1 B
Box2 C
Box1 D
Box2 E

GOAL
Box1 A, B, D
Box2 C, E

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E
1
2	Box1	A		Box1	A, B, D
3	Box1	B		Box2	C, E
4	Box2	C
5	Box1	D
6	Box2	E
7
Work

Cell Formulas
Range	Formula
D2:D3	D2	=UNIQUE(A2:A6)
E2:E3	E2	=TEXTJOIN(", ",,FILTER(B2:B6,A2:A6=D2))
Dynamic array formulas.

 

[Excellin T]

How about

+Fluff v2.xlsm
	A	B	C	D	E
1
2	Box1	A		Box1	A, B, D
3	Box1	B		Box2	C, E
4	Box2	C
5	Box1	D
6	Box2	E
7
Work

Cell Formulas
Range	Formula
D2:D3	D2	=UNIQUE(A2:A6)
E2:E3	E2	=TEXTJOIN(", ",,FILTER(B2:B6,A2:A6=D2))
Dynamic array formulas.

Thank you! That does the trick! I'll have to get more familiar with the TextJoin and Filter statements!

 

[Fluff]

You're welcome & thanks for the feedback.