Creating new column from search string

[archanacg1]

I need to parse the columns for specific string like (APPLE|Dell) and if found i want to output which column i found it in separate column as source column.

I am looking for this column where the source is from..it should display all records even if there is computer null.

[BS_THE_ANALYST]

@archanacg1 what if it shows up in multiple columns?

[archanacg1]

wanted to see both. like summary,Description

[BS_THE_ANALYST · Accepted solution]

@archanacg1 is this what you're looking for:

[BS_THE_ANALYST · Accepted solution]

@archanacg1 if it features in multiple columns: