|
I'd like to have the ability to quickly edit all cities of a certain province to a new nation.
Example:
make southern US states and their cities join a Confederate States of America.
I want to sort by state, then renumber the nation code.
Example:
make ex-Soviet republic and their cities join the USSR.
I want to sort by province/region, have the old nation name become the province/region, and then renumber the nation code.
Morozovsk,29289,227,Russia,48.35,41.83
Morshansk,43311,227,Russia,53.45,41.81
Mortka,3698 ,227,Russia,59.33, 66.02
Moryakovskiy Zaton,4745,227,Russia, 56.7,84.65
Mosalsk,4320,227, Russia ,54.49,34.98
Moscow,10381222,227,Russia,55.75, 37.62
Using Excel is a hassle due to the size and sorting.
|