Data modelling challenge?

Hi all!

I want to produce a report with a chart/charts  comparing revenue by year and month.

The data I have is in the form as below. (It also contains columns for Cost of Goods, Qty Sold and Qty Purchased in the same format as revenue which I have excluded here for brevity.)

Each product has 1 row per year, Rev01-Rev12 are January to December.

I would have prefered having Year, Month, Product, Revenue as the columns, that would have made it easier to my mind  (I'm no expert!)

Could someone suggest either:

1. A method to use the data in the current form

or

2. If it does need to be changed to Year, Month, Product, Revenue as the columns, how I should best go about that?

A pointer to a resource where I could learn would also be much appreciated.

Thanks for your time and consideration.

Regards.. Nick