Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type",{"Column1"},Table3,{"Column1"},"NewColumn",JoinKind.LeftOuter),
#"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"Column1"}, {"NewColumn.Column1"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded NewColumn", each ([NewColumn.Column1] = null)),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"NewColumn.Column1"}),
#"Removed Blank Rows" = Table.SelectRows(#"Removed Columns", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
#"Removed Blank Rows"
Bookmarks