Hi All,
I have an excel spreadsheet that currently lists all of my clients(by account number) and all of their deposits made to my bank for the past 2 years. However, the clients are listed everytime they made a deposit, so if you can imagine, I have in column A1 many duplicated account numbers, Column B1 the date of each deposit, and column C1 the deposit amount.
My goal is to use this dataset and create a report that lists only each account number once, and then lists all the months from Jan '07 to Dec '08 at the top, and then assign each month when the client made a deposit/deposits. So for example, here is account number 001's history in excel:
A1 B1 C1
001 11/07/07 $329
001 12/07/07 $360
001 12/13/07 $50
001 12/22/07 $600
001 4/01/08 $50
And I want CRXI to show:
Acct. # Nov '07 Dec '07 Jan '08 Feb '08 Mar '08 Apr '08
001 $329 $1010 $0 $0 $0 $50
Of course, as much automation as possible is ideal because I have over 13000 entries!
Thank You very much!
Frank