title: SQL Server Merge 2 rows into 1
body: <p>Is it possible to merge 2 rows into a single row in SSRS 2008?
  Each part will have a record for each site</p>
  
  <pre><code>+---------------+-------+-------+
  |Part Number    |Cost   |Site   |
  +---------------+-------+-------+
  |1              |2.4    |Site 1 |
  |1              |68.8   |Site 2 |
  +---------------+-------+-------+
  </code></pre>
  
  <p>Desired Result</p>
  
  <pre><code>+-----------+-------+-------+
  |Part Number|Site 1 |Site 2 | 
  +-----------+-------+-------+
  | 1         |2.4    |68.8   |
  +-----------+-------+-------+
  </code></pre>
  
  <p>Thank you</p>