Hello
Is there a way to remove duplicates from formula outcome. I use concatifs function, but it lists a warehouse name every time the criteria matches, but one mention would be enough.

The formula I use:
HTML Code: