Maybe you don't have this option, but you can export both lists to csv,
combine in a single file using notepad or similar, and use that file as the
external source for the pivot table.

"Hood" wrote:

What if I have two lists in two files each with about 59000 rows but with the
same structures. Multiple Consolidation only seems to allow me to summarize
on one key. I need the resulting pivot to summarize by sales, product group,
and period number. If only I could have more rows in one file !