Pivot Table with Multiple lists

Question

I have over 70k elements that I want Excel to put into a pivot table.  I have one list on Sheet1 and the second list on Sheet2.  The columns of each sheet are the same, I just ran into the 65,536 row limit.  How would I get the ~5k rows of Sheet2 to be appended to the data of Sheet1 when Excel starts parsing the data to make the pivot table for me?

Answer 1

Hi, you can combine both data in one pivot table see Debra explanation and example is called mmulti consolidation sheets

http://www.contextures.com/xlPivot08.html