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 ...
In C2:
=IF(A2=A1, "", TEXTJOIN(", ", TRUE, FILTER($B$2:$B$1000, $A$2:$A$1000=$A2)))
Fill down.