title: Print different text from the same variable in excel
body: <p>I have a spread sheet in excel / google sheet (link below)</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1kw9JLNBDlWtqyWqvySVhBtz4Hz7oiPn6/edit?usp=sharing&amp;ouid=109626011108852110510&amp;rtpof=true&amp;sd=true" rel="nofollow noreferrer">google sheet here</a></p>
  <p>The problem is :</p>
  <p>There are two columns: 1) for id and 2) some text related to the id</p>
  <p>I want to print all the unique texts (concatenate like) from the same id number in a another cell.</p>
  <p>Any help who I can do that?</p>
  <p>I have tried vlookup but does not work.</p>
  <p>Hypothetical example is the below table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>VAR1</th>
  <th>VAR2</th>
  <th>RESULT</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>ONE</td>
  <td></td>
  </tr>
  <tr>
  <td>A</td>
  <td>TWO</td>
  <td>ONE,TWO</td>
  </tr>
  <tr>
  <td>B</td>
  <td>THREE</td>
  <td></td>
  </tr>
  <tr>
  <td>B</td>
  <td>FOUR</td>
  <td>THREE,FOUR</td>
  </tr>
  <tr>
  <td>C</td>
  <td>FIVE</td>
  <td>FIVE</td>
  </tr>
  <tr>
  <td>D</td>
  <td>SIX</td>
  <td>SIX</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><a href="https://i.stack.imgur.com/THa9B.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/THa9B.jpg" alt="enter image description here" /></a></p>