PDA

View Full Version : Creating a Pivot Table Based on Two Tables



jazz2409
05-15-2020, 02:39 AM
Hello, is there a way to create a Pivot Table out of two tables without using a data model?

Thank you! :)

Paul_Hossler
05-15-2020, 11:40 AM
With some restrictions, you can create a Consolidated PT

https://support.office.com/en-us/article/consolidate-multiple-worksheets-into-one-pivottable-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5

jazz2409
05-16-2020, 11:53 PM
I have read about that already but couldn't really figure it out :rofl:
Anyway I decided to no longer do this :banghead: