In the "BOM" Sheet I have the components code which are repeating multiple times in Bom sheet and the components code have different "comp qty" in front of them. So I want the copy the components code in my "Source" sheet only one time and sum the consumption against the single component code. In "source" sheet there is only one component code with sum of "comp qty" in front of them. no duplication of component code in source sheet.