Re-organizing data

[Doffie]

Pre-emptive "many thanks" to those who share their time and expertise here.

I need to re-organize data in the following format:
Parameter, place, year, month1, month2, month 3 through 12.
Parameter 1, A, 2005, Value1, Value2, Value3, ...
Parameter 2, A, 2006, Value1, Value2, Value3, ...
Parameter 3, A, 2007, Value1, Value,2 Value3, ...
Parameter 1, B 2005, Value1, Value2, Value3, ...
Parameter 2, B, 2006, Value1, Value2, Value3, ...
Parameter 3, B, 2007, Value1, Value2, Value3, ....

to this format:
Place, year, month, parameter1, parameter2, parameter 3
A, 2005, month1, Value1, Value2, Value3
A, 2005, month2, Value1, Value2, Value3
A, 2005, month3, Value1, Value2, Value3
.. Through12...
A, 2006, month1, Value1, Value2, Value3
Through 12
2007, month 1
Through 12
B, 2005, month1, Value1, Value2, Value3
etc

I've tried pivot tables but presumably I'm doing it wrong.
Another option would (again presumably) be lookup or indexes with lots of If/and etc but its too many balls in the air for me.
Thanks
D