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

[Ravitosh Kumar]

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.

[#2]

@Ravitosh Kumar 

You may add column as

..., each [Custom][Column1]

expand resulting lists to rows and filter as needed.