find disinct strings across multiple columns

[Diarmuid]

using the columns highlighted in green below as input, I want to create the blue columns as output, whereby I determine the number of distinct strings, and then list them. The first part [count distinct] is easy, but I am unable to find a way to do the latter, i.e. find the distinct strings across all the input columns, and list them. Any and all help greatly appreciated. thanks

[atcodedog05 · Accepted solution]

Hi @Diarmuid 

Edit: I had missed out few requirements. Updating my workflow.

Here is how you can do it.

Workflow:

Hope this helps : )

[Christina_H]

Here's my solution:

[AngelosPachis]

Hey @Diarmuid ,

Here's my take on it

If you are sure that you will always get 4 columns at your input, I think @Christina_H solution works better as it seems to be more subtle.

Best,

Angelos

[Diarmuid]

fantastic, thanks a lot guys, especially for such a quick response. I wasn't aware of the unique tool, that was the missing piece of the puzzle. thanks again

[atcodedog05]

Happy to help : ) @Diarmuid 

I would definitely suggest you to check others solutions too it will help you get different prespective 🙂

Cheers and have a nice day!