title: Transpose in Datatable in ASP.NET
body: <p>I have DataTable with two Column as "ID", "Value" with data as:</p>
  
  <p><pre><code>ID    Value
  A   100
  A   200
  A   300
  A   400
  A   500
  B   -100
  B   -99
  B   -98
  B   -97
  C   1
  C   2
  C   3
  C   4
  </code></pre></p>
  
  <p>I want to display this in GridView as:</p>
  
  <pre><code>
  A   B   C
  100-100 1
  200 -99 2
  300 -98 3
  400 -97 4
  </code></pre>
  
  <p>Which is the best way to Transpose  this in DataTable. It would be really helpful if any one can provide an example.</p>
  
  <p>Regards</p>