combine columns datas for identical values in first column

Last try

PHP Code: 

=LET(z,test2!C2:I50,p,INDEX(z,,1),t,INDEX(z,,2),u,UNIQUE(FILTER(p,p)),
d,IFERROR(SUBSTITUTE(FILTERXML("<x><m>"&TRIM(SUBSTITUTE(SUBSTITUTE(TRIM(CONCAT(IF(p,"|"&INDEX(z,,7)," ")))," ","</m><m>"),"|"," "))&"</m></x>","//m")," ","|"),""),
CHOOSE({1,2,3,4},u,FILTERXML("<x><m>"&SUBSTITUTE(TRIM(CONCAT(IF(t=0," ",t)&TEXT(INDEX(z,,4),"(0);(-0);")))&"</m></x>"," ","</m><m>"),"//m"),TRIM(RIGHT(SUBSTITUTE(d,"|",REPT(" ",9)),9)),d))