Grouping Data

DaveCh · #10 06-08-2016, 07:30 AM

In row 2 you have route 1. You want to rename 10, 20, 27, 34 etc to their actual name? Correct.

Like 10 might be Austin and 20 might be New York? Correct.

So for row 17, would the 20 there also be New York and on row 27, would the 10 there be Austin? Correct.

Is this a one off or will you be constantly doing this for a larger set of data? There is another data similar to this that I'd be working on soon.

Can you simply not do a find and replace or would that be overly time consuming?I can definitely replace county codes with the actual names by using 'Replace All'. However, I still need to regroup by counties. That is, I will need to show which routes are in each county.

If F/R is not an option, would a macro work for you? A macro would work too.

Please explain #2 from post #1 in clearer detail! As you have seen, the original data is grouped based on Route numbers. Instead, I want to regroup it based on counties, so that I'd be able to see, for an example, that in Austin county (code 10 in your example above) routes 1 (column 1, row 2) and 20 (column 1, row 27) run through it.
I hope I have made myself clear now.

Do you basically want to transpose your data? Please see the above explanation.

Do you need to upload a sheet with your expected results? Yes.

Your feedback is greatly appreciated.
Dave

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vba macro code for grouping the data based on 2 hours time	dharani suresh	Excel Programming	5	04-29-2014 03:25 AM
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