Help separating multiple data from one cell to individual row

[thekodak]

I don’t know what to call this, but someone has had to have done this before. Sorry if I’m searching for the wrong words on here, but I can’t find the answer.
Thanks for your help in advance.
I’m getting a data dump of random contact information, most of it I can sort pretty easy except the contact information for emails. They need to go into the system a certain way and I don’t know how to code it effectively. There’s most likely going to be a lot of these. If I can figure out an effective way of doing it, I’ll be a hero over here.
The dump the data dump is giving me names and emails. I’m getting multiple emails in one cell. I need to break them up by name into multiple rows. Each account has will have a random number of emails.
For example
a b c

1 Bob smith Email@yahoo.
Email@google.
Email@somewhere
2 Mary smith mary@mary.co
3 Joe ken joe@joe.com
ken@joe.com

I need them to look like this.
A B C
1 Bob smith Email@yahoo.
2 Bob smith Email@google.
3 Bob smith Email@somewhere
4 Mary smith mary@mary.co
5 Joe ken joe@joe.com
6 Joe ken ken@joe.com

I don’t understand how micros work so there’s an Excel code that would be great.

Thanks for your help!

 

[thekodak]

OK this dosn't look right at all...
its look like this
a b c

1 Bob smith Email@yahoo.
Email@google.
Email@somewhere
2 Mary smith mary@mary.co
3 Joe ken joe@joe.com
ken@joe.com

I need them to look like this.
a b c
1 Bob smith Email@yahoo.
2 Bob smith Email@google.
3 Bob smith Email@somewhere
4 Mary smith mary@mary.co
5 Joe ken joe@joe.com
6 Joe ken ken@joe.com