Hey everyone,

First post here- hoping to get some help.

I'm working on a project where I have two main values (a material # and a code for orders)... the Material # is in Column A and the Order Codes are in Column B... my issue is I need to combine all unique codes for each part and put that result in Column C.

Might be good to give you an example...

A (Material) B (Code) C (What I'm looking for)
78987 0409
78987 0952
78987 1354
78987 1217 = 0409, 0952, 1354, 1217
68877 0744
68877 0988
68877 0855 = 0744, 0988, 0855
53122
53122

and so on...

I have to do this for a few thousand pieces so I'm definitely looking for some sort of equation that can be copied down or something of that nature. So I'm really trying to combine the values in Column B based on if they share the same value in Column A. I think this should be easy but I'm hitting a sort of "excel-block" (writers block of excel...)

Thanks for the help.