Manage Data, split cell data

[AbrahamGluck]

I have a list sheet with customer data, see below

Abraham	Gluck	718 111 2121	example@example.com
Moses	Grace	845 343 3434	example@example.com
Miriam & Mindy	Smith	347 243 2433 fax	example@example.com and@Iol.com

<tbody>
</tbody>

I want to split off the third row into 2 separate rows, I have hundreds of rows and quite a lot of this example of row 3.

so it will looks like this table below

Abraham	Gluck	718 111 2121	example@example.com
Moses	Grace	845 343 3434	example@example.com
Miriam	Smith	347 243 2433 fax	example@example.com and@Iol.com
Mindy	Smith	347 243 2433 fax	example@example.com and@Iol.com

<tbody>
</tbody>

 

[akmatz]

Hello. Are they all entered exactly the same way with the & in between the two first names?

 

[AbrahamGluck]

Hello. Are they all entered exactly the same way with the & in between the two first names?

Yes, all the same.