Combine items from two pivot tables into the third table

Dear all,

I am currently having a problem combining information from two tables. I will try to explain what exaclty I am trying to do here and I hope someone can help me out with it. I’ll be very grateful!

So I have two Pivot table on one Excel Sheet. The first Pivot table has names in the first columns and other data for analysis in the following columns. The second Pivot table looks the same, but the names are different, because the filtering is different as well. BUT: all the names from table 2 are present in Table 1. Here is an example:

Pivot Table 1, Column 1

By: Regina