Expanding a One to Many Delimited Column Relation

Hi,   I currently have columns like this: Column 1A Column 2A ID 1 abc ID 2 abc,xyz ID 3 efg,xyz ID 4 abc,efg,xyz   And I would like to end up with this: Column 1B Co...