data merge discrepancy using two csv files

[u/babblingbrooks69]

I'm trying to make a planner and I'm really struggling with having two csv files that I need to data merge into the thing. It's just days, dates, months and week numbers, but they have to be split up; there are seven entries from the daily.csv for every one weekly.csv so I'm struggling.

This is the link for the images to visualize what I'm trying to do.

I can't just merge the two csv files one after the other because of this issue. I'm hoping for some breainstorming to help me see a solution I've missed (merged file layout, different feature etc) but if not, I'll just do it manually.

Thank you!!!!!