I have a questionnaire in Excel that depending on the answer will have a final list of items.
For example:
Question 1 if answered with YES there will be CAT in the list, otherwise Dog.
Question 2 if answered with YES will have Parrot in the list, Otherwise Elephant.
I would like to create a conditional for these questions and create a single cell with the final list.
It would be like Python's append() but in excel lol
Thanks