Using MS Query to do a Jion for pivot table data
 

I have a excel file "database" it has two tabs that have a failry large
amount of data on each with two named ranged "range1" "range2"(exact same
layout). I want to use ms query to do a join to combine both into one pivot
table.

can any one give me some assistance

thanks
--
Helping Is always a good thing