I am working with a long column of comma separated data which relates to a column of model id numbers.

The model id number represents a product and the comma separates cell represents the model id numbers for related products.

I need to take the comma separated model id numbers , from a single cell, and blow them out into their own cells.

The goal is to create a one to one relationship between model id number and associated related products.

the date looks like this:

4 35, 36, 45
5 45, 52, 74
6 50, 60, 15
7 78. 33. 11

I need it to split out to:

4 35
4 36
4 45
5 45
5 52
5 74
etc.

Idea?