How to rearrange this csv email+name list - pls help

[phelix]

Hi, sorry this has nothing to do with Zennoposter - just really looking for answer to this question.
Couldn't find "offtopic" section on this forum.





I have a .csv list of emails + names.
Each name can have 1-3 emails along with it (which are currently separated by a comma).
I need to convert this into a .csv list where its 1 name and 1 email.

Here is example:

John Smith,johnsmith1@gmail.com,johnsmith2@gmail.com,johnsmith3@gmail.com
Taylor Smith,taylorsmith@gmail.com
Jack Smith,jacksmith1@gmail.com,jacksmith@gmail.com
...(and there are like 10k more rows)

How can I automatically convert this to:

John Smith,johnsmith1@gmail.com
John Smith,johnsmith2@gmail.com
John Smith,johnsmith3@gmail.com
Taylor Smith,taylorsmith@gmail.com
Jack Smith,jacksmith1@gmail.com
Jack Smith,jacksmith@gmail.com

The main problem here attaching the name to separate rows of the emails that were intially with that name.

I appreciate any help - seems like an easy task, but was stuck on this for few days already, Thanks.

 

[myndeswx]

This will work only for 3 emails maximum, if you would have more emails (columns) just repeat the steps in the template.
However, if there were more columns it would make more sense to split the list like that -
name;email,email2,email3,email4

Then in the template you would take from the table
column A = {name}
column B = list of emails
then replace , with a new line, and add that list of emails to a temporary list, then just take one by one from the list and add them to the table, hope it makes sense)

 

[phelix]

Hi myndeswx,

Thanks - the code you sent works PERFECT!!