Code
got it thanks, solution
ActiveCell.Formula = _
"=LET(" & Chr(10) & " val,AH2," & Chr(10) & " siz,Y:Y," & Chr(10) & " prod,AA:AA," & Chr(10) & " qty,AF:AF," & Chr(10) & " filt,TRANSPOSE(UNIQUE(FILTER(prod,siz=val)))," & Chr(10) & " sm,SUMIFS(qty,siz,val,prod,filt)," & Chr(10) & " TEXTJOIN("", "",,FILTER(sm,sm<>0)&"" ""&filt)" & Chr(10) & ")"