4 Replies Latest reply: Sep 15, 2014 3:45 AM by mayilvahanan ramasamy RSS

    How to merge similar rows

      Hi Friends,

       

      I have data like this

       

      Inline

      [

        A, B, C, Code, Amount

        1, 2, 3, PC, 900

        1,2,3,PC,900

        1, 3, 4, PM,  800

        1, 2, 4, TM, 800

        1, 2, 6, PC, 800

        ]

       

      I have to merge first two rows and amount should be 1800.

       

      Thanks