Hi Dave,

Just to make this even clearer...

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

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

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

Is this a one off or will you be constantly doing this for a larger set of data?

Can you simply not do a find and replace or would that be overly time consuming?

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

Please explain #2 from post #1 in clearer detail!

Do you basically want to transpose your data?

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