I have a list of locations and associated email addresses which I need separated out, but I need to retain/duplicate the location name.

For instance, the top set is how it is currently in excel and the bottom is how it needs to look. Any ideas?


Location A email1@host.com, email2@host.com
Location B email3@host.com, email4@host.com

Location A email1@host.com
Location A email2@host.com
Location B email3@host.com
Location B email4@host.com