Require assistance for comparing multiple columns

Hello

If my post helped you, please give me a 👍kudos and mark this post with Accept as Solution.

Here is the customized code based on your sample data.

let
    Quelle = Table.FromRecords({
        [Student district ID = 5555, Student Names = "Archibald, Alexander", Student names having taken the test = "Divers, Anthony"],
        [Student district ID = 5341, Student Names = "Bard, Christopher", Student names having taken the test = "Fold, Marc"],
        [Student district ID = 7521, Student Names = "Chambers, Leon", Student names having taken the test = "Archibald, Alexander"],
        [Student district ID = 6123, Student Names = "Divers, Anthony", Student names having taken the test = ""],
        [Student district ID = 8196, Student Names = "Extravagant, Pete", Student names having taken the test = ""],
        [Student district ID = 9865, Student Names = "Fold, Marc", Student names having taken the test = ""]
    }),
    Type = Table.TransformColumnTypes(Quelle,{{"Student district ID", Int64.Type}, {"Student Names", type text}, {"Student names having taken the test", type text}}),
    Students = Type[[Student district ID],[Student Names]],
    Merge = Table.NestedJoin(Type, {"Student names having taken the test"}, Students, {"Student Names"}, "Test", JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Merge, "Test", {"Student district ID"}, {"Student district ID Taken"})
in
    Expand

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github