Jacob, that worked! Thank you for your quick reply.

Pete, the most is about 15

"Pete_UK" wrote:

In your real data, how many Bob's are you likely to have? (i.e. the
maximum number of values that will be in that combined cell).

Pete

On Aug 31, 6:51 pm, AmyB wrote:
I've got a spreadsheet set up like this:

Col A: Col B:
Bob M10767
Carol C216
Bob Z2196
Jeff D7534
Bob D7535

If I make a list of all of the criteria in Column A, is there a formula that
will concatenate all of Column B's information into one cell?

Something like this:

Bob M10767, Z2196, D7535