title: How do I pivot my data using a T-SQL query
body: <p>I need to pivot my data so that the classification and Trade appear as headers. Below is an an example dataset.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Description</th>
  <th>Status</th>
  <th>Issue_number</th>
  <th>Custom_Label</th>
  <th>Custom_Value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Hydraulic</td>
  <td>Open</td>
  <td>680</td>
  <td>Classification</td>
  <td>Major</td>
  </tr>
  <tr>
  <td>Hydraulic</td>
  <td>Open</td>
  <td>680</td>
  <td>Trade</td>
  <td>Pumps</td>
  </tr>
  <tr>
  <td>Electrical</td>
  <td>Closed</td>
  <td>681</td>
  <td>Classification</td>
  <td>Minor</td>
  </tr>
  <tr>
  <td>Electrical</td>
  <td>Closed</td>
  <td>681</td>
  <td>Trade</td>
  <td>Electrical</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is my required output:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Description</th>
  <th>Status</th>
  <th>Issue_number</th>
  <th>Classification</th>
  <th>Trade</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Hydraulic</td>
  <td>Open</td>
  <td>680</td>
  <td>Major</td>
  <td>Pumps</td>
  </tr>
  <tr>
  <td>Electrical</td>
  <td>Closed</td>
  <td>681</td>
  <td>Minor</td>
  <td>Electrical</td>
  </tr>
  </tbody>
  </table>
  </div>