title: Formula to create a row for every value of a comma-delimited list - GSheets
body: <p>I am trying to write a formula that will take a set of columns and pair them into separate rows with a comma-delimited list. In SQL, I would do this with a left join, but I am not sure how to leverage GSheets functions for this.</p>
  <p>Here is what I mean:</p>
  <p><strong>Source Data</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Col1</th>
  <th>Col2</th>
  <th>CommaDelim</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Col1Val1</td>
  <td>Col2Val1</td>
  <td>1,2,3</td>
  </tr>
  <tr>
  <td>Col1Val2</td>
  <td>Col2Val2</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Col1Val3</td>
  <td>Col2Val3</td>
  <td>1,2</td>
  </tr>
  <tr>
  <td>Col1Val4</td>
  <td>Col2Val4</td>
  <td>1,2,3,4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>Desired Output</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Col1</th>
  <th>Col2</th>
  <th>CommaDelim</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Col1Val1</td>
  <td>Col2Val1</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Col1Val1</td>
  <td>Col2Val1</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Col1Val1</td>
  <td>Col2Val1</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Col1Val2</td>
  <td>Col2Val2</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Col1Val3</td>
  <td>Col2Val3</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Col1Val3</td>
  <td>Col2Val3</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Col1Val4</td>
  <td>Col2Val4</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Col1Val4</td>
  <td>Col2Val4</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Col1Val4</td>
  <td>Col2Val4</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Col1Val4</td>
  <td>Col2Val4</td>
  <td>4</td>
  </tr>
  </tbody>
  </table>
  </div>