Transposing Data from Columns to Rows

Hi All,

I new to Macro programming in Excel 2003 and I need to write a macro to convert data from columns to rows.

Basically I have dates along the columns from say column B onwards, then down the rows I have products, in the cells in the matrix I have volume data.

I need to transpose the data into a nice neat bloke suitable for a pivot table, can anyone help?

Thanks

Dave

PS I have attached a basic example of "as is" data and the desired result