Consolidation question

How do I consolidate and analyse data from five sheets, all with the heading project but with some entries missing on some sheets? The spreadsheet has 215 rows in total but when I consolidate with mi...

excel

PeterBartholomew1

Silver Contributor

Jul 05, 2022

et
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Project", type text}, {"Start", type date}, {"End", type date}}),
    #"Merged Queries" = Table.NestedJoin(#"Changed Type", {"Project"}, Table2, {"Project"}, "Table2", JoinKind.LeftOuter),
    #"Expanded Table2" = Table.ExpandTableColumn(#"Merged Queries", "Table2", {"Manager"}, {"Table2.Manager"})
in
    #"Expanded Table2"

PeterBartholomew1

Bungle20120

Copper Contributor

Jul 05, 2022

Thanks Peter

Forum Discussion

Consolidation question

Resources