Question
How 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 |
5 | Spot | 12 |
6 | Bella, Rosa | 7, 9 |
7 | Whiskers, Mittens, Snowball | 3, 2, 1 |
8 | Snowball, Cloudy, Spot | 7, 8, 2 |
9 | Spot | 9 |
10 | Spot, Rocky | 2, 1 |
11 | Spot | 7 |
12 | Spot, Rocky | 2, 5 |