2 Replies Latest reply: Feb 16, 2012 2:18 PM by Heri Zhang RSS

    How to grouping value of one column?

    Heri Zhang

      Hello,

       

      I have sample data like this :

       

       

      ID     Name      Value        Amount

      1      AA            P100        2000

      1      AA            P200        2500

      2      BB            H100        1000

      2      BB            J100         2500

      2      BB            H200        2300

      3      CC            A100        1000

       

      what i want is group the value of column 'Value' like this:

      ID     Name      Value                            Amount

      1      AA            P100, P200                 2000

      2      BB            H100, J100, H200       2500

      3      CC            A100                           1000

       

      how to solve it? I'm appreciate for all your response. Thanks.