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.
Sally bread, eggs, cheese
Amy bread, sugar
Will get converted to:
Can someone give me a macro that will do this, that I can re-use whenever I get new data?