create table t1(id int ,name varchar(20),c1 varchar(20),c2 varchar(20),c3 varchar(20) );

insert into t1 values (1,'wc','as','','');
insert into t1 values (2,'wc','asd','','');
insert into t1 values (3,'wc','','fdf','');
insert into t1 values (4,'wc','','','er');
insert into t1 values (5,'wd','fg','','');
insert into t1 values (6,'wd','fgo','','');
insert into t1 values (7 ,'wd','','ko',''); 
commit;

select name,
       substr(c1,instr(c1,',',-1)+1,length(c1)) c1,
       substr(c2,instr(c2,',',-1)+1,length(c2)) c2,
       substr(c3,instr(c3,',',-1)+1,length(c3)) c3
from (select name,
         wm_concat(c1) c1,
         wm_concat(c2) c2,
         wm_concat(c3) c3
     from t1
     group by name)


     name    c1    c2    c3
----------------------------------------
1    wc    asd    fdf    er
2    wd    fgo    ko