Excel sheet messed up

[Mehrez Kanzari]

Hi Friends,

I have an issue which’s the following:

I downloaded an excel sheet but it was all messed up.

What I need is to separate all the data and make a proper format also delete specific columns from it (prefix and country code).

I’m thinking about writing a script to do this in an automated way but I don’t know how to do it (I don’t have an experience in scripting).
I’m open for any others suggestions that could resolve this issue.

Please refer to the following attachment for more informations.

Thanks in advance!