I would first use a CROSSTABLE LOAD to get the Month header as field Value in e.g. a new Month field.
Please check the Crosstable load in the Help (and then you could use the assistent in the editor).
This should give you a table with one row per year and month, and still a connected Field with values 00101010100111... or similar (binary flags for Open/Close).
Then use a should transform Year and Monthname to a date MonthStartField using monthstart(Makedate(Year, right(Monthfield,2)))
One more load will transform the FlagFields into one record per Day
Mid(FlagField,iterno(),1) as OpenFlag,
Makedate(year,Month(MonthstartField),iterno()) as Date
resident ... while iterno() <= day(monthend(MonthStartField))
Maybe something like this, I think.
Hope this helps,
edit: Please look at attached sample.
CrosstableFlags.qvw 155.0 K