need to arrange column wise data to row wise with monthly wise

Thanks a lot Pete..
if i need to add more consumers data then how could i add those data so that it would be populated in drop down and i can see the summary results for all consumers.
I have attached full data sheet if you can apply the same on full data.