consolidate identical reports

[sandy666]

try Power Query

let
    Source = Table.Combine({Table1, Table2}),
    #"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Name.1", each _, type table [Name=text, Revenue=number, Purchases=number]}, {"Revenue", each List.Sum([Revenue]), type number}, {"Purchases", each List.Sum([Purchases]), type number}}),
    #"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Name.1"})
in
    #"Removed Columns"

Book1.xlsx