Okay So, I have a BOM, in a pretty standard format where it lists all the Designators, for the specific Part number. I am making a Pick and Place File, in which all of the Designators are Separate. I need the Part Number for Each Designator. Is there a Macro that can pull, the Part Number from the BOM, and list it for each designator.



IE:

C1, C2, C3, C4, C5, C6, PART NUMBER 1
C7, C8, C9, PART NUMBER 2


INTO


C1 PART NUMBER 1
C2 PART NUMBER 1
C3 PART NUMBER 1
C4 PART NUMBER 1
C5 PART NUMBER 1
C6 PART NUMBER 1
C7 PART NUMBER 2
C8 PART NUMBER 2
C9 PART NUMBER 2