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