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

Anna
Wiebke
Carl
Anthony
Dimitriy
Nicola
Jack
Alina
Max
Anthony
Carl
Jack

 

 

 

Pivot Table 2, column 2

Anthony
Carl
Jack
 
 
 I want to combine names from the first two tables into the third one so that first, there are names that are present in both tables and then all the rest from the first Pivot table that are not found in the second one. I am trying to find a formula for that. The difficulty is that since those are pivot tables, the number of names and the content differs depending on the applied filters. That is how I want the third table to look like:
 
Anthony
Carl
Jack
Anna
Wiebke
Dimitriy
Nicola
Alina
Max

 

I would appreciate any help or hints. Thank you in advance

 
 
 
 

 

 

By: Regina

Leave a Reply

Your email address will not be published. Required fields are marked *