Building a pivot table from two different tables in Excel for Mac

[Nathalie Sicard]

Hello everyone,

I am trying to build a pivot table from two different tables in Excel, I read about "Data Model" but it's just not there in Excel for Mac, which I have.

Any ideas of how this can be done?

My excel version: 15.13.1

Thank you!

 

[RoryA]

You can't use the Data Model on Mac. What do your tables look like and what's the connection between them?

 

[Nathalie Sicard]

You can't use the Data Model on Mac. What do your tables look like and what's the connection between them?

Thank you Rory

I have two tables, one has shipments, the other one has sales. Just a lot of data, and then I'd connect them through an item number, to get a pivot table that summarises shipments for that item and sales for that same item.

Thank you!

 

[RoryA]

Realistically I'd say your best bet is to combine the two tables into one using lookup formulas and then pivot that.