Combining more than 10 tables data in to one table

Question

In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". However I couldn't seem to find the same option to do it in Excel 2007. Any ideas?

Answer 1

I believe you can press Alt+D and then P, which will open the PivotTable Wizard as per previous versions of Word.

From there you can use the Multiple Consolidation options you require.