let
Source = Excel.Workbook(File.Contents("C:\Users\alans\OneDrive\Desktop\File 1.xlsx"), null, true),
Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"FW_Name", type text}, {"D13", Int64.Type}, {"D14", type text}, {"D15", Int64.Type}, {"D16", Int64.Type}, {"D17", Int64.Type}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type",{"FW_Name"},Test_Basic,{"FW_Name"},"Test_Basic",JoinKind.FullOuter),
#"Expanded Test_Basic" = Table.ExpandTableColumn(#"Merged Queries", "Test_Basic", {"FW_Name", "D13", "D14", "D15", "D16", "D17", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16"}, {"Test_Basic.FW_Name", "Test_Basic.D13", "Test_Basic.D14", "Test_Basic.D15", "Test_Basic.D16", "Test_Basic.D17", "Test_Basic.Column7", "Test_Basic.Column8", "Test_Basic.Column9", "Test_Basic.Column10", "Test_Basic.Column11", "Test_Basic.Column12", "Test_Basic.Column13", "Test_Basic.Column14", "Test_Basic.Column15", "Test_Basic.Column16"}),
#"Reordered Columns" = Table.ReorderColumns(#"Expanded Test_Basic",{"FW_Name", "Test_Basic.FW_Name", "Test_Basic.D13", "Test_Basic.D14", "Test_Basic.D15", "Test_Basic.D16", "Test_Basic.D17", "Test_Basic.Column7", "Test_Basic.Column8", "Test_Basic.Column9", "Test_Basic.Column10", "Test_Basic.Column11", "Test_Basic.Column12", "Test_Basic.Column13", "Test_Basic.Column14", "Test_Basic.Column15", "Test_Basic.Column16", "D13", "D14", "D15", "D16", "D17"}),
#"Removed Columns" = Table.RemoveColumns(#"Reordered Columns",{"Test_Basic.Column7", "Test_Basic.Column8", "Test_Basic.Column9", "Test_Basic.Column10", "Test_Basic.Column11", "Test_Basic.Column12", "Test_Basic.Column13", "Test_Basic.Column14", "Test_Basic.Column15", "Test_Basic.Column16"}),
#"Reordered Columns1" = Table.ReorderColumns(#"Removed Columns",{"FW_Name", "Test_Basic.FW_Name", "Test_Basic.D13", "D13", "D14", "Test_Basic.D14", "D15", "Test_Basic.D15", "D16", "Test_Basic.D16", "D17", "Test_Basic.D17"})
in
#"Reordered Columns1"