Data merge weekly planner with complex daily content

Hi, everyone!

I am making a weekly planner in InDesign where each day should have listed the sunrise, sunset, moonrise, moonset etc. for three different cities. I have no problem using data merge to fill in all the correct months and dates, but I'm having trouble figuring out how to include all the solar and lunar stats without creating a monster of a spreadsheet.

The challenge is that one row in the spreadsheet represents one week of data in InDesign. And having so many data points for one week, is creating a horrible spreadsheet.

How can I do this? 

Attached images:

– calendar-week.png: How it should look (though I haven't fixed the image of the lunar phases yet, which also needs to be included in the spreadsheet eventually)

– calendar-spreadsheet.png: Spreadsheet where I have all the date-stuff figured out, and only startet to outline the daily time stamps. But it's going to look insane, as there will be 13 data points for each day, and then there is 7 days in a week, so there is going to be 91 data points just for the solar and lunar stats for one week ...