Excel sheet messed up

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!

Hi, welcome to the Forums!

Did you check out the Excel help pages by any chance? I’ve been there myself for both excel and tableau and ppl have been helpful. Plus, there are a ton of pages devoted to issues ppl have encountered before.

Off the top of my head, you could just go to the Data Tab and “text to columns” to split the data into different columns.

https://support.microsoft.com/en-us/office/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23

1 Like