Moving results of merged data into rows

[Merlin]

Here is a tricky one .. at least for me.

I have 'Item' numbers down one column and the 'Year' down the next column. I have Months across the top. I would like to rearrange this data into Items down one column, but merge the Year to the Months and arrange all in a row going across.

The reason is so I can import this arrangement into a forecasting application.

Any ideas?

...................Old
____________Jan__Feb__Mar
Item___Year
1000__2000___10__10__10
1000__2001___20__20__20

................Desired
_______Jan-2000__Feb-2000.....Jan-2001_Feb-2001...
Item
1000______10______10_________20______20

Thanks!