the input data is in rows one below the other while the output required is defined in the excel attached as there are only two pair of unique codes so if unique code =101 then it should be paired with 102 only taking the row data into column. eg. Input data idno. abbrivation Amt 101 asd 2000 102 dfg 2000 output expected idno Abbrivation Amt1 idno abbrivation Amt2 Difference(Amt1-Amt2) 101 asd 2000 102 dfg 2000 0 more detail willbe find in excel.
... View more