Excel DataTable Help

Hi all,

I have an excel file that looks like this,

I have to be able to separate the column from the image into 4 columns that contain their Name, Designation, Email and phone number(s) if any. And I’m not sure how to go about this, can anyone help?

This is what the output should look like