I have data of the following form:
Person : Products Ordered
Bob : ["Apples", "Oranges"]
Alice : ["Mangos", "Milk", "Tomatoes"]
Bob : ["Apples", "Bananas", "Pie"]
Alice : ["Oranges", "Milk"]
and I want to create a visualization aggregating all the products ordered by a person. So in this example,
Person Products Ordered
Bob : "Apples, Oranges, Bananas, Pie"
Alice : "Oranges, Milk, Tomatoes, Mangos"
Notice that I don't want any product duplicated in the list. Also, note that the field is a list of strings (Multi fields). How do I create this visualization? I looked for a documentation but could not find it. A Rest API for doing this is also acceptable but a visualization is more preferable. Thank you.