Code:
let
Source = Table.NestedJoin(Ramco_Modified, {"Contract #"}, Protos_Modified, {"Ramco Contract #"}, "Protos_Modified", JoinKind.FullOuter),
#"Expanded Protos_Modified" = Table.ExpandTableColumn(Source, "Protos_Modified", {"ID", "Company", "Name", "Position", "Ramco Contract #", "Date", "Day", "Start", "End", "In 1", "Out 1", "Unpaid Break Hours", "Actual Hours", "Delta Hours", "Shift End Date", "MINUTES Current Day", "MINUTES Next Day", "MINUTES Total Hours", "MINUTES Hours Var", "ROUNDED Current Day", "ROUNDED Next Day", "ROUNDED With Lunch", "ROUNDED Total Hours", "ROUNDED Hours Var", "F24", "F25", "F26", "F27", "F28", "12:00 AM", "F30", "F31", "F32", "F33", "F34"}, {"Protos_Modified.ID", "Protos_Modified.Company", "Protos_Modified.Name", "Protos_Modified.Position", "Protos_Modified.Ramco Contract #", "Protos_Modified.Date", "Protos_Modified.Day", "Protos_Modified.Start", "Protos_Modified.End", "Protos_Modified.In 1", "Protos_Modified.Out 1", "Protos_Modified.Unpaid Break Hours", "Protos_Modified.Actual Hours", "Protos_Modified.Delta Hours", "Protos_Modified.Shift End Date", "Protos_Modified.MINUTES Current Day", "Protos_Modified.MINUTES Next Day", "Protos_Modified.MINUTES Total Hours", "Protos_Modified.MINUTES Hours Var", "Protos_Modified.ROUNDED Current Day", "Protos_Modified.ROUNDED Next Day", "Protos_Modified.ROUNDED With Lunch", "Protos_Modified.ROUNDED Total Hours", "Protos_Modified.ROUNDED Hours Var", "Protos_Modified.F24", "Protos_Modified.F25", "Protos_Modified.F26", "Protos_Modified.F27", "Protos_Modified.F28", "Protos_Modified.12:00 AM", "Protos_Modified.F30", "Protos_Modified.F31", "Protos_Modified.F32", "Protos_Modified.F33", "Protos_Modified.F34"})
in
#"Expanded Protos_Modified"