title: Concatenate value by delimiter based on key match
body: <pre><code>KEY     DATE        STATUS      Item   ORDEREDQTY SHIPPEDQTY        Concat (ouput)
  1       05/11/2015  Dispatch    123     3           1            1 | 05/11/2015 | Dispatch | 123 | 3 | 1 | 321 | 2 | 1  
  1       05/11/2015  Dispatch    321     2           1
  2       14/11/2015  Dispatch    456     3           2            2 | 14/11/2015 | Dispatch | 456 | 3 | 2 | 678 | 2 | 1  
  2       14/11/2015  Dispatch    678     2           1
  </code></pre>
  
  <p>How to do the above?</p>
  
  <p>I need to concatenate <code>Item</code>, <code>originalqty</code> and <code>shipqty</code> if <code>Key</code> is matching. Above has key value as 1 and in the output column I should get the value which are having key as 1 and concatenating last three columns.</p>