I'm trying to count the number occurrences for each unique item across multiple columns. For example, I have following data across columns A, B, & C. It is a two-step process (1) figure out the unique items from all three columns as the data changes every day (2) count the number of occurrences for each unique item.
Column A
Apple
Orange
Pear
Grape
Carrot
Kiwi
Column B
Pear
Grape
Watermelon
Egg
Column C
Egg
Apple
Grape
Peanut
My desired output would be:
Apple 2
Orange 1
Pear 2
Grape 3
Carrot 1
Kiwi 1
Watermelon 1
Egg 2
Peanut 1
Bookmarks