Split table into multiple tables based on value of 2 columns

I have the same question but I think the answer will be the same: it is not possible with Power Query. My reason to split table into more tables: within one table there are records which I would like to process differently: I want to assign to the table record specific identification ID based on certain criterions (conditions) in levels of conditions: first, based on most specific condition, bridge (for merge) then if not found in the most specific bridge based on different field, less specific bridge - put into ID some average substitute ID and then third possible way if neither of the two is applicable (both merges was lef outer join) use very general substitute ID.... So I think I have to create duplicates of the whole table, or, should be better(??), reference to the original table, filter it twice and at the end append each part of such adjusted table together... The only issue with that approach is that the table is quite large so it takes more time to run all three parts of processing and then to process final resulat as one table... I think for such a task there are better tools than power query (knime e.g.) but still even this task is achievable with Power Query, just less efficient...