Excel 2007 : Converting multiple columns to multiple rows

I've been banging my head on this for a few days now. I've searched high and low across the forums, but can't seem to find a macro to get this accomplished. I'm a maintenance worker, so I'm not very comprehensive when it comes to Excel. I need a way to transpose multiple rows containing many columned dates into many many more rows. Attached is an example of what I am going for.