I am trying to convert a sheet that has cells with a list of items separated by commas into multiple rows with one item in each cell.

So:

Name Groceries
Sally bread, eggs, cheese
Sue eggs
Amy bread, sugar


Will get converted to:

Name Groceries
Sally bread
Sally eggs
Sally cheese
Sue eggs
Amy bread
Amy sugar

Can someone give me a macro that will do this, that I can re-use whenever I get new data?
Thanks, Gil