I have a list of foods in cells A1: A16 and I want to create a unique list with each item listed only once in the list:
Eggs Bacon hashbrowns Baked beans Lawyer coffee Bread Bread Sandwhich meet Salad Tomato mustard mayo Chips Cheese biscuits
I've tried the formula
= unique (transpose (split (ArrayFormula (concatenation (A1: A16 & ""),)), "")))
but it creates a unique list and divides words like "beans beans" into new elements like this:
Eggs Bacon hashbrowns Cooked Beans Lawyer coffee Bread sandwhich meet Salad Tomato mustard mayo Chips Cheese biscuits
As you can see, "cooked" and "beans" appear as two distinct elements. How can I make it an element of the new single list?