Thread: Grouping Data
View Single Post
 
Old 06-03-2016, 03:42 PM
DaveCh DaveCh is offline Windows 7 64bit Office 2013
Novice
 
Join Date: May 2016
Posts: 7
DaveCh is on a distinguished road
Default 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
Reply With Quote