Concatenate and delete duplicates

[learningexcel1]

Hello, I need a way to concatenate data and then delete the duplicates. In the attachment for the 6.10.16 Met 1 and 6 Workbook, I need a formula so the 'Cradle Pulled From' column will automatically pull which cradles from the 'live metal list' workbook, the pieces of metal are in. I already concatenated by 'part number' and 'color' but the last line, which includes all the cradles has duplicates. I believe I need a macro to prevent concatenate from using duplicate numbers, and then create a formula that copies those concatenated lists into the correct cell on the Met 1 and 6 Workbook.

I appreciate any help
Thank you

[learningexcel1]

I attached the wrong version of the 6.10.16 Met 1 and 6 schedule, here is the correct one

[learningexcel1]

ideally the final product would look like this on the 6.10.16 met 1 and 6 worksheet except with the correct cradle numbers (I just made these up)