Rename two identical values in the same field

[#1]

Hi everyone,

I have the following example:

Food	Type
Fruit	Orange
Drink	Orange

I want to rename the two 'Orange' values in the 'Type' Field differently, based on the associated values in the 'Food' Field. Does anyone know how I can do this in the script? I need help with both the method, and the syntax. I think I could use REPLACE or MAPPING, I just don't know how I would type it out.

Thanks!

[#2]

YES it worked!! Thank you Jon! And thank you Massimo, as well!