QuestionHow to create a word cloud when the data is structured as text, (or string), lists rather than a row for every possible value.
For example, 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. Similar to the table below:
|Household ID||Pet Names|
|1||Rocky, Doug, Spot|
|3||Rocky, Spot, Mittens|
|7||Whiskers, Mittens, Snowball|
|8||Snowball, Cloudy, Spot|