Multiple Search Criteria Outputs based on specific column

[Ahmad_S]

Hi Team,

I hope everyone is doing well and safe from the COVID-19.

Have a quick question, I am trying to find multiple criteria across single column and if there are multiple matches then return each match into separate column.

In the attached, I have added one filtering but I want to get output for each match filtering criteria in different column.

Appreciate if you folks and gurus can guide, how to achieve this.

Regards

[echuong1 · Accepted solution]

There are probably a few ways to do this, but the easiest method in my mind is to create separate conditional statements in the formula tool and then concatenate them together. I'd place a delimiter such as a pipe in between each so you can easily parse them apart using a text to columns tool. See attached for an example.

Let me know if that works!