Excel Table Exceeds Rows - Options for Pivot Tables

[Thaynes]

I need to create one pivot table for a report.
My data currently exceeds the rows for excel, so I took the data and put it on different tabs. The headers are the exact same, but instead of one tab with ~1M+ rows, I have two tabs with ~500K.
How can I connect these two tables to one pivot?
Everything I've read seems to indicate that the headers have to be different, with one one header connecting the two tables.

Table one Example

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Customer Name[/TD]
[TD]Region[/TD]
[TD]Dollars TY[/TD]
[TD]Dollars LY[/TD]
[/TR]
[TR]
[TD]1 Month[/TD]
[TD]Apple[/TD]
[TD]North[/TD]
[TD]500,000[/TD]
[TD]550,000[/TD]
[/TR]
[TR]
[TD]1 Month[/TD]
[TD]Best Buy[/TD]
[TD]South[/TD]
[TD]200,000[/TD]
[TD]150,000[/TD]
[/TR]
</tbody>[/TABLE]

Table Two Example
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Customer Name[/TD]
[TD]Region[/TD]
[TD]Dollars TY[/TD]
[TD]Dollars LY[/TD]
[/TR]
[TR]
[TD]1 Month[/TD]
[TD]Target[/TD]
[TD]East[/TD]
[TD]250,000[/TD]
[TD]225,000[/TD]
[/TR]
[TR]
[TD]1 Month[/TD]
[TD]Fry's[/TD]
[TD]West[/TD]
[TD]1,000,000[/TD]
[TD]700,000[/TD]
[/TR]
[TR]
[TD]1 Month[/TD]
[TD]Walmart[/TD]
[TD]North[/TD]
[TD]660,000[/TD]
[TD]880,000[/TD]
[/TR]
</tbody>[/TABLE]

****** id="cke_pastebin" style="position: absolute; top: 226px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer Name[/TD]
[TD]Region[/TD]
[TD]Dollars TY[/TD]
[TD]Dollars LY[/TD]
[/TR]
</tbody>[/TABLE]
</body>Any advice would be greatly appreciated.

 

[Michael M]

Have you looked at Debras site...

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

 

[sandy666]

You can use Power Query for

whole (1 M + rows) data
or
Append 2 tables (~500 rows) into one table

then create Pivot Table

 

[Thaynes]

Thanks - i tried and pivot on the appended data isn't working. still saying i've exceeded the rows.

 

[sandy666]

so it means there is more than 1 M unique rows in column in Rows Area
maybe try Group by Date/Customer Name/Region with Sum TY and LY then PT

(I don't know your data so it's hard to say something more)

 

[Swayzy]

Write the data to a text file and add to a data model. You can even split the table into multiple files and have them in One folder then import the folder.

Overall google a bit on Powerpivot and you will find a much more simple solution to handle millions of data rows