Two tables to a Pivot Table

[AllisterB]

Hi

I have a Client running Excel 2010. [They will not install PowerPivot ]

In a workbook they have two Tables - each on a separate sheet. The Tables have a Customer Field in common. I want to be able to combine both Tables into a Pivot Table.

I am a Advanced Excel user (20 years).

What are my Options to get the Pivot Table.

Thank You

Abee

 

[sandy666]

I have a Client running Excel 2010. [They will not install PowerPivot ]

but they can install PowerQuery

 

[AllisterB]

but they can install PowerQuery

Yes ... but they won't so I need to find a solution that doesn't use PowerPivot - perhaps a solution that worked with 2007.


Thanks

 

[sandy666]

try Alt+D+P

 

[AllisterB]

Thanks Sandy

I have just switched to a MAC so where does Alt+D+P do ?

 

[sandy666]

Option+D+P probably
you will see new window wich allow you to set two ranges and make new one (PivotTable, standard)

btw. I don't know Mac