Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi
check attach file hope it hels you
thank liron for your help.
it's working now! thanks!