Hi Lisa
If you have Power Query available to you, then you should be able to load it to the Data model for use with Power Pivot.
Within the cache there, you can have 100 million rows.
You could then write the data back out to separate worksheets of less than 1 m rows each if needed.
Bookmarks