Database entry into excel

I need the attach spread sheet completed according to the pattern described on the first row and the example shown on the second row (yellow). The spread sheet must be fully completed in the format shown on the second row. See attachment to understand. For the project to be successful, the following outcomes must be achieved: (1) All outlined cells must be completed and propagated (2) Data must be accurate, so I can easily analyse the data. I am able to assist with any questions should they be needed.