Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-03-2016, 03:42 PM
DaveCh DaveCh is offline Grouping Data Windows 7 64bit Grouping Data Office 2013
Novice
Grouping Data
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping Data Vba macro code for grouping the data based on 2 hours time dharani suresh Excel Programming 5 04-29-2014 03:25 AM
Grouping Data Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM
Grouping paragraphs h.ridinger Word 2 11-06-2013 10:42 AM
Grouping alamorchgirl PowerPoint 0 07-08-2011 02:14 AM
Grouping - expand all ejohns Excel 0 07-17-2009 07:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft