how can I show all data in several rows in column2,in this way that in both column1 &3 should be match data with each other ex:

-

if its to pull all the 3 columns & at the same time joining all results in column 2 then try this:

=BYROW(UnIQUE(A2:A),
LAMBDA(ax,IF(ax="",,{ax,JOIN(",",FILTER(B:B,A:A=ax)),XLOOKUP(ax,A:A,C:C,)})))