matching data and populating values

PLease see attchemnt for explanation of formula needed.
I have cloumn B that has some identical lot numbers, one for good production and one for bad scrap, I need a formula to find the matched lot numbers and will add the good into the same row as the bad scrap

See if this works for you. You can either insert the formula directly into the columns wherever there is a 0 or just create a separate column and then copy and paste values.

Excel example.xlsx