This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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"?