title: How to convert rows to columns in DataGridView
body: <p>I have a datagridview with </p>
  
  <pre><code>   CATEGORY         PROJECT    AMOUNT 
     ========         =======    ======
     Miscellaneous    project1     1200
     Miscellaneous    project2     4500
     Travel           project3     3000
     Miscellaneous    project4     2300
     Travel           project4     1000
  </code></pre>
  
  <p>I want to convert the above format to</p>
  
  <pre><code>       CATEGORY       project1   project2   project3    project4
         ========       ========   ========   ========    ========
         Miscellaneous   1200       4500         0         2300
         Travel           0           0         3000       1000
  </code></pre>
  
  <p>The project_name is dynamic, it can change</p>
  
  <p>pls help.....</p>