Splitting cells and rearranging data

I have a very messed up databook which now needs to be cleaned up and data segregated into columns.

I am at a loss to do this in a reasonably simple way because every "contact person" column has to be split into two or three columns and two or three rows of name, designation and cell phone number (i've made them all 123456789 for the example)

Would be grateful for help on a way to accomplish this?

Workbook extract attached.

Thanks.