Grouping text values to a consistent names

[meghakedia9792]

Hello,

I am trying to group data in a column in to standardized labels. For example, in the following data set,i want to group Apple, Banana and Blueberries and similarly Wheat and Maize to Grains. I know I can use a series of IF OR and ELSEIFs, but i'm wondering if there's an easier way. My data has over 500,000 rows and over 65 categories that are all text. Is there a way to select only the "vegetables" and replace with the word "vegetables"?

Thanks, 
Megha

Apple

Banana

Carrot

Blueberries

Wheat

Maize

Lamb

[ivoller · Accepted solution]

Can you set up a lookup table with the 65 categories and then use it as an input to the Find Replace tool?