I have a dataset, let's assume one customer in this dataset(we have thousands) Date. Customer amount install Nov2016 A 2000 0 Dec2016 A 100 Jan2017 A 100 Apr2017 A 12000 100 May2017 A 200 Jun2017 A 200 Feb2018 A 7000 200 Mar2018 A 200 Mar2019 A 5000 . Apr2019 A . I want: Nov2016 A 2000 100 APR2017 A 12000 200 Mar2018 A 7000 200 Mar2019 A 5000 . I mean, the install could start the same month as we have amnt, could start next month after amount or could be missing. I want to keep first instalment accourred after each amount for each customer. And keep them in a same row with amnt. Thanks
... View more