Hello @psfard
Please have a look to this workflow in my Hub. I think that it addresses a similar problem.
The output for your challenge ends in the first grey shaded node. The end of the workflow is a filtering issue that doesn’t apply here.
Data Wrangling _ Filtering with Wildcards (Regex Logical Indexing)
Let us know if further clarifications are needed.
BR
PS.- The logical indexing matrix can be easily unpivoted and filtered to get your desired output (being aware of a unique TRUE by row, aiming to avoid duplicates)