Hi Miguel,

The correct way to approach this is to use Power Query to combine the source data that the two PivotTables are based on, rather than building PivotTables and then getting the data from them.

It's not clear where the source data for the two PivotTables is stored, but if it's in separate sheets in an Excel file, then this tutorial on consolidating Excel sheets with Power Query may help.

Hope that points you in the right direction.

Mynda

Thanks, Mynda, for your help.

There are some conditions that I didn’t express at first hand.

This is for a Real Estate Business:

• For the same Property you can have an Agent that brings the property to sell and another Agent that finds the Buyer or the same Agent for both situations.
• All the information of one business should be in the same row

Attached is a file with all the information.

Thank you for taking the time to resolve the issue.

Hello,

Please view attached copy of your sample file. In sheet Table Example I have restructured your data into a tabular formatted table. As I worked in Excel app on an iPad I could not create a pivot table, but you will notice how much easier it is to get the data you want.

Br,
Anders

One Column with all Agents (Buyers and Sellers) the solution.

Thanks Anders

Hello,

Thank you for your feedback. This is the way the data should be structured, makes it a lot easier to get wanted data from pivot tables and functions. You can read more in the blog article Excel Tabular Data Format.

Br,
Anders