I want to create responses "nuts", "dairy", and "nuts and dairy" with no double-ups. I only want the three responses but my data currently shows about 20, each with additional info I don't actually need or want. How would I go about renaming everything so that an observation like "nuts, peanuts, almonds" would return just "nuts"?

This has to be done in Google Sheets.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.