Hello,

I am trying to merge two datasets, one with stock price, so per company an observation per business day. The other dataset has the same amount of rows, but per company only a couple observations per year (the date is a dividend announcement).
When merging, the dates should align, while sticking to the correct company, but I cannot seem to figure this out. I want to do an event study on these announcements, but in order to work the dates should be on the same row.
Is there anything I might be missing, since I do not believe this should be so difficult.

Kind regards,

Victor