I have a spreadsheet where on column can contain multiple values separated by comma's.
Sequence CPN Component Description Manufacturer MPN Qty Designators 1190 A014 7004 RoHS|YES|KOA SPEER|RK73H2BTTD8250F|RES SMT 825 OHM 1% 1/4W|(1206) KOA SPEER RK73H2BTTD8250F 2 R168,R181
What I need is:
Sequence CPN Component Description Manufacturer MPN Qty Designators 1190 A014 7004 RoHS|YES|KOA SPEER|RK73H2BTTD8250F|RES SMT 825 OHM 1% 1/4W|(1206) KOA SPEER RK73H2BTTD8250F 2 R168 1190 A014 7004 RoHS|YES|KOA SPEER|RK73H2BTTD8250F|RES SMT 825 OHM 1% 1/4W|(1206) KOA SPEER RK73H2BTTD8250F 2 R181
How would I create a macro or whatever to achieve that?
Kindly,
John
Bookmarks