Summarize 629,487 records - HELP!!!!
Posted by JAF on July 17, 2001 6:46 AM
I have a VERY large table which currently contains 629,487 records (obviously far too large to fit Excel's 65,536 row limit).
The data consists of a list of accounts and the number of months in arrears each account is at each month end. There are over 31,000 accounts covering data for 64 month ends (accounts that completed more recently obviously have less "rows" of data in the database.
In my SQL databse, the data is in the following format:
What I need to do is to somehow summarise the data in such a way that each Account_Number is listed in Column A, each Month_End_Date in row 1 in a seperate column starting at Column B, with the associated Months_In_Arrears data for each Account_Number being shown for Month_End_Date.
In other words:
I can't think of any way to summarize the data in the above format. Any suggestions???