Forum Discussion
Text Join - Return Unique Text Only
Hi, I am trying to use text join with Unique function and it does not seem to be working for text. I have successfully used it for values in the same spreadsheet but can't seem to eliminate the dupli...
In the example you share below for Dogs and Cats, I am trying to have an outcome of what pet types and what colors they are available in - both unique values based on the data in the 'original table'
Dog Black, Brown
Cat Ginger, Black, White
This is the file. I have made life more complicated by including a version that returns the colours as an array of arrays, as opposed to an array of comma-separated lists.