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

Date	Customer Name	Region	Dollars TY	Dollars LY
1 Month	Apple	North	500,000	550,000
1 Month	Best Buy	South	200,000	150,000

<tbody>
</tbody>

Table Two Example

Date	Customer Name	Region	Dollars TY	Dollars LY
1 Month	Target	East	250,000	225,000
1 Month	Fry's	West	1,000,000	700,000
1 Month	Walmart	North	660,000	880,000

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 226px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

Customer Name

Region

Dollars TY

Dollars LY

<tbody>
</tbody>

</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