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

Options

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"?

• ✭✭✭✭✭✭
Options

How many unique entries could you have across a row?

• Options

I think it would be 4 max.

• ✭✭✭✭✭✭
Options

Try the below:

=IF(CONTAINS("A", [Column3]@row:[Column6]@row), "A" + CHAR(10), "") + IF(CONTAINS("B", [Column3]@row:[Column6]@row), "B" + CHAR(10), "") + IF(CONTAINS("C", [Column3]@row:[Column6]@row), "C" + CHAR(10), "") + IF(CONTAINS("D", [Column3]@row:[Column6]@row), "D", "")

• ✭✭✭✭✭✭
Options

@Leibel S's solution should work.

• ✭✭✭✭✭✭
Options

A different solution would be if you format the column where you are placing your join into a Multi Select column and run the below function, it will automatically only show the Distinct options. (because a Multi Select can only have each value once).

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!