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 ...
Hi Syndicate_Admin,
Thanks for your help! As I'm very new to M code, may I ask why we don't convert the table to records first before turning the records to a table? Sorry, I'm having a hard time understanding how Table.SelectRows(Record.ToTable(_) works when there are no records in the previous step. The rest of your code, I understand.
When you add a column, each row is a record