Macro to convert occupancy time series data for bird houses into matrix of 1's and 0's

Hello all,


I have what I suspect is a fairly simple task. Apologies for my ignorance, I'm new to VBA. I've got some time series data on bird house occupancy I got from another birder for a set of bird houses collected at month-level resolution. The attached excel sheet is an example of the data I have (The actual data is hundreds of rows, there are a lot of bird houses, so any solution needs to be able to handle that. The attached is just an example). What I would like to do is create a macro that will take the data in the form I have it in (indicated on the attached sheet by "*Form of data I have") and use it to populate a matrix where the columns are months and the rows are bird houses (such as shown on the sheet as "Blank Matrix"). An example of the desired output for the data is shown in the filled-in matrix ("Desired Matrix"). Months in which a bird house is occupied should be denoted by 1's, months when it is not left as 0's. Note that in the columns of data as I have them all of the months between when a bird house is first occupied and when it is abandoned should also be filled in by 1's.

Thank you for any suggestions, I've been trying to teach myself how to do this for two days and I suspect it will be short order for some of you all.

Take care.

-Andy

Thank you to you both! Reputation buttons clicked.