Sheet2 PQ
let
Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
#"Merged Queries" = Table.NestedJoin(Source, {"MATERIAL CODE"}, Table3, {"MATERIAL CODE"}, "Table3", JoinKind.LeftOuter),
#"Expanded Table3" = Table.ExpandTableColumn(#"Merged Queries", "Table3", {"Column3"}, {"Table3.Column3"}),
#"Grouped Rows" = Table.Group(#"Expanded Table3", {"MATERIAL CODE"}, {{"Count", each _, type table [MATERIAL CODE=text, Table3.Column3=nullable text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each [Count][Table3.Column3]),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Count"}),
#"Extracted Values" = Table.TransformColumns(#"Removed Columns", {"Custom", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Sorted Rows" = Table.Sort(#"Extracted Values",{{"MATERIAL CODE", Order.Ascending}})
in
#"Sorted Rows"
Bookmarks