title: Remove Duplicates
body: <p>I have a table like below:</p>
  
  <pre><code>SuppID   AreaID     SuppNo   SupName    SupPrice
  ------------------------------------------------
  1        3            526    ANC         100 
  1        3            985    JTT         200
  3        4            100    HIK         300 
  </code></pre>
  
  <p>In the above table, for same SuppID(1) and same AreaID(3), different SuppNo are there (526 &amp; 985) in two different rows.</p>
  
  <p>In this scenario , I'd like to make those two rows into a single row with SuppNo field as blank.</p>
  
  <p>Also my output result should display rows with all the columns.</p>
  
  <p>Any Help?</p>