QuestionHow to create a view using data is structured as text, (or string), lists rather than a row for every possible value.
This article contains two examples: Making a word cloud of pet names, but each row in the underlying data lists all of the pets in one household as a comma separated list. Or finding the average of pet ages per household where every row contains a comma separated list of ages.
Similar to the table below:
|Household ID||Pet Names||Pet Age|
|1||Rocky, Doug, Spot||1, 6, 10|
|2||Spot, Whiskers||4, 5|
|3||Rocky, Spot, Mittens||2, 4, 6|
|4||Minnie, Mickey||1, 1|
|6||Bella, Rosa||7, 9|
|7||Whiskers, Mittens, Snowball||3, 2, 1|
|8||Snowball, Cloudy, Spot||7, 8, 2|
|10||Spot, Rocky||2, 1|
|12||Spot, Rocky||2, 5|