Hi! I have a single column with multiple products all of them separate by ";" I need use this column such a filter but I need in this filter just appears each single product not the multiple combinations there are. Any help greatly appreciated.

If I filtered product 1, I would have to see these rows (all rows that has product 1) and so

and if I use CONTAINS as a result per each row just appears one product and excludes the others products that has that row

IF CONTAINS([Column 1],"Product 1") THEN "Product 1"

ELSEIF CONTAINS([Column 1],"Product 2") THEN " Product 2"

ELSEIF CONTAINS([Column 1]," Product 3") THEN " Product 3"

END