Grouping Data
Hi folks,
I have bunch of sporadic data ranging from assigned code numbers 1 to 58, each representing a specific county, such as 1 for Marin County, 2 for Monterey, etc.
In addition, I have numbers, ranging from 1 to 980, assigned to specific (roadway) routes, such as 1 for Hwy 1, 80 for Interstate 80, etc.
Currently, I have a head list of routes, under which are the corresponding county number(s).
Now, I want to:
1) Name counties by their actual name, rather than their assigned code;
2) Completely reverse the data arrangement; that is, have the routes fall into each corresponding county.
How do I do it? Can it be done at all? Any help will greatly be appreciated.
Dave
|