Splitting Data Based on Data Value
<p>I have a Data like below.</p>

<pre><code>OrderDate  OrderID  TotalOrderPrice
*********************************
1/10/2010   ABC        100
1/10/2010   ABC        200
1/20/2010   ABC        150
1/26/2010   ABC        100
1/10/2010   EDF        200
1/20/2010   EDF        110
1/26/2010   EDF        120
****************************
</code></pre>

<p>I want the final output so that I can see how much is the sum of <code>OrderPrice</code> for the particular <code>OrderID</code> on a particular <code>OrderDate</code> as shown below</p>

<pre><code>OrderDate    ABC    EDF
************************
1/10/2010    300    200
1/20/2010    150    110
1/26/2010    100    120
</code></pre>

<p>Can anyone guide me on how to achieve this? How can I query the DataTable to get this result?</p>

<p>Thanks &amp; Regards</p>
