Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t(id int, code varchar(30),date1 varchar(10), name varchar(30))
insert into t values(1,'code1', 'date1', 'name1');
insert into t values(2,'code2','date2', 'name1');
insert into t values(3, 'code3', 'date3', 'name2');
1 rows affected

1 rows affected

1 rows affected

select name
      ,replace(replace(cast(array_agg(col_txt) as varchar(1000)),'}',''),'{','') as concat_val
 from (
       select id,code as col_txt,name
         from t
        union all
       select id,date1,name
         from t
       order by 3,1  
       )grp
group by name


name
concat_val


name1
code1,date1,code2,date2

name2
code3,date3