How to merge two datasets with different time periods

Hi,

I have two datasets (one with monthly data and one with quarterly data) about two different variables but about the same companies (see attachment).

Exccel.JPG
Exccel2.JPG

I want to merge them to make one dataset with monthly data. For the quarterly data, I want to convert that to monthly by just taking the last available quarterly data. So for example, for December 98 I want to have the LV ratio of December 98 (which is the end of the quarter) together with the monthly return of that company for December 98. For January 99, it would be the LV ratio of December 98 (latest available quarter), but the monthly return for January 99 (see attachment).

Exccel3.JPG

I want to tell Excel to identify each company by its isin code and give from each sheet the LV ratio and return for a given time and for the LV ratio --> if date < next quarter but > previous quarter, take previous quarter.

I hope it's clear enough

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

Where are the examples of the manually calculated expected results???