Guys

i have a spreadsheet with Column A1 being a part number and D1 being a list of comma seperated designators

I want to be able to expand the list from

A1 B1
C0001 D1, D2, D3
C0002 G4,G8,G9
C0008 Z23,Z67

to be

C0001 D2
C0001 D2
C0001 D3
C0002 G4
C0002 G8


etc etc

Can you see a simple way to do this as i have lots of lines to do

Adrian