Looking for macro to create new records based on values in a cell
I have a spreadsheet where some of the cells have multiple entries. I would like to be able generate new rows based on the values in that cell until all the multiple entries have been produced. For example in the graphic below, new rows should be created for the values in column E where there is more than one. For example, if there are four items in a cell that would mean four new rows with all the values for the row repeated, but with the values in column E only occurring one time each. It could be in the same spreadsheet or a different one.