Manage Data, split cell data

[AbrahamGluck]

I have a list sheet with customer data, see below

[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Abraham[/TD]
[TD]Gluck[/TD]
[TD]718 111 2121[/TD]
[TD]example@example.com[/TD]
[/TR]
[TR]
[TD]Moses[/TD]
[TD]Grace[/TD]
[TD]845 343 3434[/TD]
[TD]example@example.com[/TD]
[/TR]
[TR]
[TD]Miriam & Mindy[/TD]
[TD]Smith[/TD]
[TD]347 243 2433 fax[/TD]
[TD]example@example.com and@Iol.com[/TD]
[/TR]
</tbody>[/TABLE]


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
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Abraham[/TD]
[TD]Gluck[/TD]
[TD]718 111 2121[/TD]
[TD]example@example.com[/TD]
[/TR]
[TR]
[TD]Moses[/TD]
[TD]Grace[/TD]
[TD]845 343 3434[/TD]
[TD]example@example.com[/TD]
[/TR]
[TR]
[TD]Miriam[/TD]
[TD]Smith[/TD]
[TD]347 243 2433 fax[/TD]
[TD]example@example.com and@Iol.com[/TD]
[/TR]
[TR]
[TD]Mindy[/TD]
[TD]Smith[/TD]
[TD]347 243 2433 fax[/TD]
[TD]example@example.com and@Iol.com[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.