Forum Discussion
My Formula Isn't Working!
My Excel spreadsheet is currently set up like this (pretend these are Columns A and B, in order): Person Possible Cupcake Flavors Michael Red Velvet Michael ...
=BYROW(A2:A9,LAMBDA(row,IF(COUNTIF(A2:row,row)=1,TEXTJOIN(",",,FILTER(B2:B9,A2:A9=row)),"")))An alternative could be this formula which spills the results.