Power Query M Code - Select Columns if the Header contains two specific values

Hi, ajay_gajree 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may add a new step with the following m codes.

= Table.SelectColumns(
         #"Changed Type",
         List.Combine({
         {"Entry ID"},
         List.Select(
                Table.ColumnNames(#"Changed Type"),
                each Text.Contains(_,"51")
         )
         })
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.