I have to consolidate data from multiple files as shown below in Name Column. Custom column contains data in the tables.
Excel Query Screenshot
One of the Table preview is shown above and I want to filter data in Column1 that matches the condition. Example: Select all rows with text "Exempt" or "Particulars" etc.
I used Table.SelectRows but following error is shown
After query error
Please suggest what formula to use to get desired results.
You may add column as
..., each [Custom][Column1]
expand resulting lists to rows and filter as needed.