Textjoin: To show distinct and ignore blanks

[JaiPrakash]

Need help to get only distinct values from a list using Text Join

ID	Sequence​
Task 1	0.1​
Task 1	0.2​
Task 1	​
Task 1	0.1​
Task 2	0.1​
Task 2	0.1​
Task 2	0.3​
Task 2	​

Trying to get only distinct values from Sequence column for its respective tasks

ID	Sequence
Task 1	0.1,0.2,0.1
Task 2	0.1,0.1,0.3

What do I need to add in the existing formula so that it shows only distinct: =TEXTJOIN(",",TRUE,IF($AT$2:$AT$9=$AW2,TRIM($AU$2:$AU$9),""))

Thanks!!!

 

[jasonb75]

If you have office 365 then try

=TEXTJOIN(",",1,UNIQUE(FILTER(TRIM($AU$2:$AU$9),$AT$2:$AT$9=$AW2)))

I don't have 365 to test it but based on the examples that I found, I think that I have the syntax correct.

 

[JaiPrakash]

Thanks so much, Jason. That did it.