Forum Discussion
Olei_pq
Oct 05, 2025Occasional Reader
Power Query- filter Table by a keyword list, partial match
Hello,
I have been looking for a solution for a while now to filter a table column with text (approx. 2000 rows) using a list (approx. 50) of keywords in Power Query. The list should be editable by the user in Excel and also contains partial words that I want to identify in the table.
Texts in the table column are usually companies with different spellings, e.g.
Amazon Germany, Amzn US, Bosch, Bsh, Glashuette, glashutte,
Search terms: amazon, bsh, bosch, glash
I have already found solutions for exact matches.
Thank you very much for your help and the great work of the community.
Best regards Oliver