I have an Excel worksheet that has two columns, in one is the name, in the other there are one or more emails, separated by a comma.

Now, I want to get two columns with repeated names but unique emails, so no more than one email address in a single cell, I just want column one to have a name and column two to have an email.

Now it is like this:

name1    email1, email2, email3
name2    email1
name3    email1, email2

And I want it like this:

name1    email1
name1    email2
name1    email3
name2    email1
name3    email1
name3    email2

thanks