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

[Mehrez Kanzari]

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:

 

[SkipVought]

Hi,

Please delete your other thread in Forum68 and proceed in this thread only.

What's wrong with COPY N PASTE?

BTW, it will help your chances to get a solution, if you post a working copy or representation of your data, rather than a picture that cannot be pasted into Excel.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Andrzejek]

I am with Skip:
[ul]
[li]Insert a new column between C and D[/li]
[li]Select values from Network column and CUT (Ctrl-X)[/li]
[li]Paste them in the new, inserted column[/li]
[li]Select values from NetworkName column and CUT (Ctrl-X)[/li]
[li]Paste them in the Network column[/li]
[li]Select values from inserted column and CUT (Ctrl-X)[/li]
[li]Paste them in the NetworkName column[/li]
[li]Delete empty column from step 1[/li]
[/ul]


---- Andy

There is a great need for a sarcasm font.

 

[SkipVought]

@Andy, please do not insult the intelligence of this Systems Engineer who ought to be able to figure out these simple steps on an Excel Sheet.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Andrzejek]

Sorry... Didn't mean to insult anybody


---- Andy

There is a great need for a sarcasm font.