Count number of occurrences of each items of a list

[gutoferrari]

I have a table that contains a list column.

I would like to count how many occurrences of each item in a list.

How do I do this?

List: Bananas, Bananas, Bananas, Apple, Apple, Orange

On the screen, I would like to see the total of the list items:

Fruit	Quantity
Bananas	3
Apple	2
Orange	1

[mateo]

Hi @gutoferrari,
What about this topic? 
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Count-how-many-times-an-item-appear-in-a-text-l...
It is kinda limited but I guess will work in this case.

[AleksiAlkio]

How about using grouped table view and then aggregate the quantity? Then you would not need any virtual column for the calculation.

[nicolasfsamaja]

In VIEWS, as Aleksi says, use Gruop by "Fruit" and Group Aggregate COUNT "Row number" for example