# How to group multiple values with same identifier

#### Excellin T

##### New Member
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

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### Fluff

##### MrExcel MVP, Moderator
+Fluff v2.xlsm
ABCDE
1
2Box1ABox1A, B, D
3Box1BBox2C, E
4Box2C
5Box1D
6Box2E
7
Work
Cell Formulas
RangeFormula
D2:D3D2=UNIQUE(A2:A6)
E2:E3E2=TEXTJOIN(", ",,FILTER(B2:B6,A2:A6=D2))
Dynamic array formulas.

#### Excellin T

##### New Member
+Fluff v2.xlsm
ABCDE
1
2Box1ABox1A, B, D
3Box1BBox2C, E
4Box2C
5Box1D
6Box2E
7
Work
Cell Formulas
RangeFormula
D2:D3D2=UNIQUE(A2:A6)
E2:E3E2=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

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
1
Views
71
Replies
10
Views
168
Replies
0
Views
128
Replies
0
Views
88
Replies
3
Views
247

1,127,463
Messages
5,624,877
Members
416,064
Latest member
PaulBr2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back