title: SQL Server pivots? some way to set column names to values within a row
body: <p>I am building a system of multiple trackers that are going to use a lot of the same columns so there is a table for the trackers, the tracker columns, then a cross reference for which columns go with which tracker, when a user inserts a tracker row the different column values are stored in multiple rows that share the same record id and store both the value and the name of the particular column. </p>
  
  <p>I need to find a way to dynamically change the column name of the value to be the column name that is stored in the same row.</p>
  
  <p>i.e.</p>
  
  <pre><code>id | value | name
  ------------------
  23 | red   | color
  23 | fast  | speed
  </code></pre>
  
  <p>needs to look like this.</p>
  
  <pre><code>id | color | speed
  ------------------
  23 | red   | fast
  </code></pre>
  
  <p>Any help is greatly appreciated, thank you.</p>