Want to seperate Multiple Lines in a cell to mutiple rows

Hello,

I am brand new to this forum. Please bear with me as i am still learning. I have a challenge where in have a list of about 4000 rows and each cell have mutiple lines. ( i know there is a thread about this but that did not address my issue).

So my data is as follows - (I have attached teh sample file)

"Pari bom - GP and CFO 02547895452 [email protected]

papa bom - GP and CFO 23365789541 [email protected]

mama bom - CFO 2587412589 [email protected]

nana bom - CFO 2587412589 [email protected]

masi bom - CFO 2587412589 [email protected]

"

I want to be in a position to seperte each line in exclusive rows and then seperate teh name, number and the email ... the later eing easier but cant get my head around seperating the cells.

I hope sone is able to rescue me.

Prakash