How to grouping value of one column?

[#1]

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.

[lironbaram · Accepted solution]

hi

check attach file hope it hels you

[#3]

thank liron for your help.

it's working now! thanks!