title: SQL 2008 Combining data from multiple rows with the same ID into one row
body: <p>I have data in one table that contains several rows of data for the same CardNum. I would like to create a table where all the data for the same CardNum is displayed on the same row.</p>
  
  <p>My data is currently like this:</p>
  
  <pre><code>PartID | CardNumber | RdrGrpID | TZID
  
  0         412         31         1
  0         412         34         1
  0         567         38         1
  0         567         33         5
  0         567         71         3
  </code></pre>
  
  <p>This is how I would like the data to be:</p>
  
  <pre><code>PartID | CardNumber | RdrGrpID_1 | TZID_1 | RdrGrpID_2 | TZID_2 | RdrGrpID_3 | TZID_3
  
  0         412         31           1        34           1
  0         567         38           1        33           5        71           3
  </code></pre>
  
  <p>Thank you in advance.</p>