title: Split columns including comma separated values into rows + count occurrences of each value (parsing raw Google Form results)
body: <p>I'm trying to split a large number of columns in Google Sheets, where some of them include a variable number of comma separated values.</p>
  <p>Here's a simplified version of what I'm trying to accomplish.</p>
  <p>I want to take a spreadsheet like this one (out of a Google Form):</p>
  <pre><code>| Name       | Qualities                                    | Colors         | Origins  |
  +------------+----------------------------------------------+----------------+----------+
  | apple      | sweet,hard,round, this is my favorite fruit  | red, green     | gb, us   |
  | banana     | soft,small                                   | yellow, brown  | us       |
  | orange     | round,healthy, sour                          | orange         | nl       |
  | watermelon | round, healthy                               | green, red     | us       |
  </code></pre>
  <p>And transform it into this:</p>
  <pre><code>| Name                      | Count |
  +---------------------------+-------+
  | apple                     |1      |
  | banana                    |1      |
  | orange                    |1      |
  | watermelon                |1      |
  +---------------------------+-------+
  | Qualities                 |       |
  +---------------------------+-------+
  | round                     |3      |
  | healthy                   |2      |
  | hard                      |1      |
  | small                     |1      |
  | soft                      |1      |
  | sour                      |1      |
  | this is my favorite fruit |1      |
  +---------------------------+-------+
  | Colors                    |       |
  +---------------------------+-------+
  | red                       |2      |
  | green                     |2      |
  | brown                     |1      |
  | orange                    |1      |
  | yellow                    |1      |
  +---------------------------+-------+
  | Origins                   |       |
  +---------------------------+-------+
  | us                        |3      |
  | gb                        |1      |
  | nl                        |1      |
  </code></pre>
  <p>Here is the same as <a href="https://i.stack.imgur.com/0RHAp.png" rel="nofollow noreferrer">a screenshot</a></p>
  <p>I have tried <a href="https://stackoverflow.com/questions/63193639/how-do-you-separate-comma-separated-values-in-different-columns-while-maintainin">this</a> and similar answers, none of which did exactly what I need. I wish I had more to show in ways of code examples, but so far nothing I tried to make myself was even remotely close to helpful.</p>
  <p>I'm open to solutions involving draggable formulas or even custom scripts. Any pointers will be appreciated really :)</p>