The answer to your direct question is YES, data can be embedded in a pivot table. However, since you specify "more than a million rows" and "disconnected from any database," the answer to the implied application is NO. You will not get more than a million rows in an Excel spreadsheet. And I would venture to say that a million rows do not belong to the spreadsheet.
I think one of the goals of the pivot table is to give you the ability to summarize data from an external source. If you can (or think you can) combine the data with a pivot table and download the whole mess, why not make a resume yourself and download only the summary data? It would be interesting to know more about the actual application.