title: Convert multi-row table into one row based on identifier and column values in SQL?
body: <p>Here is the Table I am working with (Table1):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customer ID</th>
  <th>Month</th>
  <th>Amount Paid</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ABC123</td>
  <td>1</td>
  <td>10</td>
  </tr>
  <tr>
  <td>ABC123</td>
  <td>2</td>
  <td>20</td>
  </tr>
  <tr>
  <td>ABC123</td>
  <td>3</td>
  <td>30</td>
  </tr>
  <tr>
  <td>ABC123</td>
  <td>4</td>
  <td>40</td>
  </tr>
  <tr>
  <td>ABC999</td>
  <td>1</td>
  <td>15</td>
  </tr>
  <tr>
  <td>ABC999</td>
  <td>2</td>
  <td>30</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is what I want my new table to look like (Table2):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customer ID</th>
  <th>AmtPaid_M1</th>
  <th>AmtPaid_M2</th>
  <th>AmtPaid_M3</th>
  <th>AmtPaid_M4</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ABC123</td>
  <td>10</td>
  <td>20</td>
  <td>0</td>
  <td>40</td>
  </tr>
  <tr>
  <td>ABC999</td>
  <td>15</td>
  <td>30</td>
  <td>0</td>
  <td>0</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to just have one row per Customer ID that shows how much they paid each month, instead of having the ID repeated for each month. Is there a simple way to do this using joins or case when statements? Thank you!</p>