My Original Data :
id | GRP_ID | VAL_1 | VAL_2 | VAL_3 | TYPE
---------------------------------------------------
1 | R2 | B01 | | | COL_B
2 | R2 | | A01 | | COL_A
3 | R3 | B02 | | | COL_B
4 | R1 | | C01 | | COL_C
5 | R2 | C02 | | | COL_C
6 | R3 | | | C03 | COL_C
Then i modified like this :
-----------------------------------------
GRP_ID | group_CONCAT1 | group_CONCAT2
-------------------------------------------
R1 | COL_C | C01
R2 | COL_A,COL_B,COL_C | A01,B01,C02
R3 | COL_B,COL_C | B02,C03
And i want get result like this :
GRP_ID |COL_A | COL_B | COL_C
----------------------------------
R1 | --- | --- | C01
R2 | A01 | B01 | C02
R3 | --- | B02 | C03