Forum Discussion
List Column Headers Of Columns In Which Text String Appears
Hi all, CGPT and Bing AI weren't helping, so I want to see if this sub can help. So, I have the following table in Power Query: column1 column2 column3 apple juice pear orange apple fig ...
=Table.AddColumn(YourTable,"Custom",each Text.Combine(Table.SelectRows(Record.ToTable(_),each Text.Contains([Value],"apple",Comparer.OrdinalIgnoreCase))[Name],","))