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