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

Sorry all it should read "nice neat block" not "bloke" oops

Try the attached.

Aye if your talking whisky Martin ...
On that note the pub beacons ...

Thanks, will give it a go when I get back to my PC and let you know how it goes

Cheers, many thanks