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 |
Solved! Go to Solution.
Can you set up a lookup table with the 65 categories and then use it as an input to the Find Replace tool?