How to fix a messed Excel sheet and make a proper format?

[mkanzari]

I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by switching places between the content of the following columns: "Network" and "NetworkName" from line 14. Please refer to the following screenshots to explain more the situation:

 

[Fluff]

Duplicate How to fix a messed Excel sheet and make a proper format?

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).