I am working on a calculated field. Is there an Group By aggregate that will list all the values in the group into one field.
Example, I want this:
Name | Food |
---|---|
John | Apple |
John | Banana |
John | Orange |
John | Tomatoe |
Mary | Banana |
Mary | Beans |
Mary | Kiwi |
Joe | Orange |
Joe | Banana |
To be this:
Name | Food |
---|---|
John | Apple, Banana, Orange, Tomatoe |
Mary | Banana, Beans, Kiwi |
Joe | Orange, Banana |