Forum Discussion
Interpolating values between two dates
Hi,
I hope you are all well!
I currently have a dataset containing monthly financial data and quarterly financial data. I wish to linearly interpolate the quarterly data to monthly data so I can conduct some analysis between the two sets of financial data. I was using the excel 'fill' function to fill the blank cells as a linear trend but the full dataset spans 15 years; I found this process quite slow since I could only fill 2/3 months at a time. I'm looking for a more efficient way to complete this task.
I have attached a screenshot of some of the dataset which should help explain my situation. As you can see I have filled 'Div. Growth' using the excel 'fill' function but given the frequency of the data in the dataset I can only interpolate 2-3 cells at a time.
All help is appreciated!
Thanks!