I have a survey result with a checkbox question in which more than one answer could be checked. The results are given in a single column, separated by a
AWS 20 GCP 5 Pizza racks 1 Azure 1 ...
What Have I Tried
SPLIT, but then the count spans multiple rows
- Exporting to CSV and some Python-foo, but it's manual and error-prone
How can I
QUERY COUNT a row which with one or more values in each cell, separated by a delimiter?