Merge two tables

[Hokeycokey]

Hi. I have two identical tables in one file on two different sheets. I want to merge the two tables into one sheet where the sum of each table is totalled and not side by side.
I can merge them side by side by power query but can't merge them as a sum.
Any ideas would be much appreciated, thanks

 

[ranman256]

put both on the same sheet, 1 below the other,
run a pivot table to sum.

 

[Hokeycokey]

Thanks
Do I do that as a power query?
I got them side by side by when I did a pivot table it didn't sum then