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