Excel DataTable Help

[testingtesting123]

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?

[testingtesting123]

This is what the output should look like