# Conditional concatenation

#### agillespie

##### New Member
Good morning. Got kind of a tricky issue here that I am trying to resolve without getting into a nasty multiple OFFSET nested in VLOOKUP nested in CONCAT statement. I have a sheet which lists out combinations of individuals associated with a specific piece of information, with each row being unique to that piece of information (ex. Row 1: Person A and B are associated with item 1, Row 2: Person C is associated with item 2, Row 3: Person D is associated with item 3, Row 4: Person A and B are associated with item 4). I am trying to figure out a way to concatenate items associated with each unique combination of individuals in another worksheet. Using the example, the output would be:
Combination Result (including a "," in the CONCAT)
Person A and B 1, 4
Person C 2
Person D 3

Is there any easy way to do this? Many thanks.

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Replies
2
Views
240
Replies
0
Views
213
Replies
6
Views
358
Replies
3
Views
67
Replies
2
Views
533

1,195,582
Messages
6,010,577
Members
441,557
Latest member
Jbest23

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