Morning everyone. I have a problem in calculating data under this situation:
I have 2 sets of data: One set have information for every single month. And another set only have 3 to 4 months data per year (monthly data). I want to multiply data according to month. If there is any missing data in any month, I will use the any avaible data before that.
Example: Data Set A has data 12, 13, 15 for Jan, Feb, March
Data Set B has data 0.5, X , 0.17 for Jan, Feb, March
In order to calculate Feb, I will use data from Jan (0.5) for Feb.
1. I have no idea how to do it;
2. There is no pattern in missing data. So, if I miss out 3 months data, I will use data 4 month ago.