Pivot Table with 1M+ rows of data

[lost_in_the_sauce]

I'm using Excel 365 and am trying to help someone create a pivot table from a ton of customer data, the 2 tables she is trying to aggregate together are 800K rows and 513K rows. I know Pivot likes to stop at 500K. I tried making both worksheets into tables and using Pivot Table Wizard but unsurprisingly got the low memory error.

Is there a workaround for this amount of data?

 

[James006]

Hi,

Take a look at Power Query ...

 

[lost_in_the_sauce]

Hi,

Take a look at Power Query ...

Ah, thank you.

I'm not well versed in Power Query, I was able to load both worksheets into the Power Query Wizard, but am unsure where to go from there, currently watching YouTube videos trying to figure it out.

 

[James006]

You are welcome

How to get data into Power Query - 5 common data sources

When working with Power Query, the first thing we need to do is get data into Power Query. We look at Workbooks, CSV, Text and from Table/Range

exceloffthegrid.com

 

[alansidman]

Can you provide some sample data (8-10 records for each table) so that we can demo this for you and get you on the right path. Please use XL2BB to upload your sample data