Formula to return values from a spreadsheet with specific parameters

[cazmantis]

Sorry I don't know a better way to word this! I have attached a spreadsheet which shows an example of the data set I am looking at.

I have data for a range of organisations split out into months. I am interested in getting the total value of each month for each organisation so I would like to be able to extract this data from the spreadsheet. No matter how I try I can't force a pivot table to give me this and was hoping I could perhaps write some code (eg everytime you see Jan-16 in a cell, return me the value directly under this (that will be the total) and also the value in the row below and two cells to the left (that will be the Organisation name).

Anyway I think it's clearer if you look at the spreadsheet - anyone have any ideas of how I can extract the data I want?

Thanks!

Caz