Select Rows from specified column of Table for multiple rows of data tables

Occasional Contributor

I have to consolidate data from multiple files as shown below in Name Column. Custom column contains data in the tables.

Excel Query ScreenshotExcel 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 errorAfter query error


Please suggest what formula to use to get desired results.

1 Reply

@Ravitosh Kumar 

You may add column as

..., each [Custom][Column1]

expand resulting lists to rows and filter as needed.