title: Split multiple question answer from Google Forms by phrases in Google Sheets
body: <p>I have a Google Sheet created after filling the Google Form with multiple answer questions</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Timestamp</th>
  <th>Event</th>
  <th>First name</th>
  <th>last name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1/10/2021 18:11:01</td>
  <td>Event A</td>
  <td>Jane</td>
  <td>Jones</td>
  </tr>
  <tr>
  <td>1/10/2021 18:12:35</td>
  <td>Event A, Event B</td>
  <td>Joe</td>
  <td>Jones</td>
  </tr>
  <tr>
  <td>1/10/2021 18:14:26</td>
  <td>Event B, Event C</td>
  <td>Jennifer</td>
  <td>Adams</td>
  </tr>
  <tr>
  <td>1/10/2021 18:15:35</td>
  <td>Event A, Event C</td>
  <td>John</td>
  <td>Smit</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The problem is that Event A and Event B may have commas itself like &quot;Walk, Ride&quot; or &quot;Swim, Jump&quot;. In Google Sheets it looks like &quot;Walk, Ride, Swim, Jump&quot;</p>
  <p>I want to split this multiple answers column by phrases &quot;Walk, Ride&quot; and &quot;Swim, Jump&quot; to get something like. How can I do that?</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Timestamp</th>
  <th>Event</th>
  <th>First name</th>
  <th>last name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1/10/2021 18:11:01</td>
  <td>Event A</td>
  <td>Jane</td>
  <td>Jones</td>
  </tr>
  <tr>
  <td>1/10/2021 18:12:35</td>
  <td>Event A</td>
  <td>Joe</td>
  <td>Jones</td>
  </tr>
  <tr>
  <td>1/10/2021 18:12:35</td>
  <td>Event B</td>
  <td>Joe</td>
  <td>Jones</td>
  </tr>
  <tr>
  <td>1/10/2021 18:14:26</td>
  <td>Event B</td>
  <td>Jennifer</td>
  <td>Adams</td>
  </tr>
  <tr>
  <td>1/10/2021 18:14:26</td>
  <td>Event C</td>
  <td>Jennifer</td>
  <td>Adams</td>
  </tr>
  <tr>
  <td>1/10/2021 18:15:35</td>
  <td>Event A</td>
  <td>John</td>
  <td>Smit</td>
  </tr>
  <tr>
  <td>1/10/2021 18:15:35</td>
  <td>Event C</td>
  <td>John</td>
  <td>Smit</td>
  </tr>
  </tbody>
  </table>
  </div>