title: How to rearrange select result using condition in LINQ
body: <p>I am new to linq I am looking for solution for following table. 
  Here is my table structure
  <a href="https://i.stack.imgur.com/IrsDd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IrsDd.png" alt="enter image description here"></a></p>
  
  <p>By using <code>TransType</code> as condition I want to create two new columns <code>Credit</code> and <code>Debit</code> and want to show data according <code>TransType</code> condition.</p>
  
  <p>like following screenshot.
  <a href="https://i.stack.imgur.com/NplYR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NplYR.png" alt="enter image description here"></a> </p>
  
  <p>Can you please suggest me LINQ select query to get result according to 2 screenshot.
  Thank You.</p>