Source Result ColumnA ColumnB Data1 Data2 ColumnA NotMatchB Data1 Data2 USNTS USNTS ABC 123USNTS USSPZ ABC 123USNTS USSPZ ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USNTS USLVV ABC 123USLVV USNYC ABC 123USMSY USMSY ABC 123USHOU USHOU ABC 123USMSY USMSY ABC 123USMSY USMSY ABC 123USLVV USNYC ABC 123USNYC USNYC ABC 123
Code:// Table1 let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Diff = Table.AddColumn(Source, "NotMatchB", each List.Difference({[ColumnB]},{[ColumnA]})), Expand = Table.ExpandListColumn(Diff, "NotMatchB"), Filter = Table.SelectRows(Expand, each ([NotMatchB] <> null)), TSC = Table.SelectColumns(Filter,{"ColumnA", "NotMatchB", "Data1", "Data2"}) in TSC






Bookmarks