Hi, I have a data set with the monthly outstanding balances from all my customers, from 2000 until now. This isn't at customer level. The data set that I have mentioned, contains all the payments that I have received from my customers from 1990 until today. And it is obviously at customer level. What I 'm trying to do is; For any given month, let's say Jan - 00, to track all the monthly payments (by using the data set that i have shown to you) that I have received from that point until today. And I have to repeat that for all months from Jan-00 until today. That's why I am trying to put my data set in that format. Given the size of the data sets, I think that it would be better to reference somehow to these payments, instead of transforming my data But I don't know if that is feasible.
... View more