title: SQL Cross-tab of descriptive information
body: <p>looking for some help on how to transform some data.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Entity_ID</th>
  <th>Entity_Name</th>
  <th>Field_Name</th>
  <th>Field_Value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Entity_A</td>
  <td>results.Address</td>
  <td>123 ABC Way</td>
  </tr>
  <tr>
  <td>1</td>
  <td>Entity_A</td>
  <td>results.City</td>
  <td>Wonkaland</td>
  </tr>
  <tr>
  <td>...</td>
  <td>...</td>
  <td>...</td>
  <td>...</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Field_Name has 50 different possible values, and I'm interested in presenting a subset of those values as column headers in a query result. Example desired result shown below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Entity_ID</th>
  <th>Entity_Name</th>
  <th>results.Address</th>
  <th>results.City</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Entity_A</td>
  <td>123 ABC Way</td>
  <td>Wonkaland</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I've used pivots for this type of query in the paste, but always when I'm aggregating results. Any guidance / recommendations?</p>