How to combine pivot tables in excel

When most people use PivotTables, they replica the source data into a worksheet, then carry out lots of VLOOKUPs to get the categorization columns stimulus the data set. After that, the statistics is ready, we can create spiffy tidy up PivotTable, and the analysis can produce. But we don’t need to prang all those VLOOKUPs anymore. Instead, we buoy build a PivotTable from multiple tables. By creating relationships between tables, surprise can combine multiple tables which accordingly creates the lookups for us.

The power to create relationships has been natively available in Excel since 2013, even most users don’t even know that feature exists.

We don’t need to replicate and paste data into a worksheet either as we can now apply Power Query to import the list directly. Check out my Power Query programme to understand how to do this. But, for this post, we are plan on creating relationships and how come to combine two PivotTables.