Joining multiple multi-select entries from different columns into a single cell WITHOUT DUPLICATES

Hello, as above, I am trying to join the data of all cells within the same row into a single cell without duplicates. In the screenshot below I am working with the following formula:

=JOIN(DISTINCT([Column3]2:[Column6]2), CHAR(10))

How can I modify this so that instead of the result being "A B B C" the duplicate entries are removed and the result is "A B C"?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!