title: CloudWatch Query join two records having same id
body: <p>I have a cloudwatch log in the following format</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>name</th>
  <th>city</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>John</td>
  <td></td>
  </tr>
  <tr>
  <td>1</td>
  <td></td>
  <td>New York</td>
  </tr>
  <tr>
  <td>2</td>
  <td></td>
  <td>Seatle</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Mike</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I am looking for a way to fetch log data in the following format combining empty and non-empty values</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>name</th>
  <th>city</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>John</td>
  <td>New York</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Mike</td>
  <td>Seatle</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>How can I achieve this using CloudWatch log filter query?</p>