Hi Everyone,

I am new in this website and I find this awesome with lots of cool information about excel!

I would like to ask your help.

Suppose we have a data like these:

Name Account # Region Country
Person A "10001,10002,10003,10004" North America USA
Person B "10005,10006" Asia China
Person C "10007,10008,10009" Europe Germany

And assuming that we have tons of records like these. I would like to separate each "Account #" per row and retain all the rest of the columns. Is there a faster way for me to change it like the one below without doing it manually per row?


Name Account # Region Country
Person A 10001 North America USA
Person A 10002 North America USA
Person A 10003 North America USA
Person A 10004 North America USA
Person B 10005 Asia China
Person B 10006 Asia China
Person C 10007 Europe Germany
Person C 10008 Europe Germany
Person C 10009 Europe Germany

Thank you