PIVOT TABLE FOR 2 WORKSHEET SOURCES (MORE THAN 65000 ROWS)

[jimboy.javier]

hi good morning!

how can i make two(2) worksheets with more than 60000 rows as my data source in creating a pivot table? i've tried the multiple consolidation function but it does not give my desired output.

i need help asap!

thank you!

 

[Mark W.]

Treat each worksheet as a separate table, create a SQL query that UNIONs the two data sets, and use this query as the data source for your PivotTable.