urgent transpose macro needed -

Column A B C
Company1 2005 2006
Company2 2003 2004 2002
..
..
..

i need a macro so that it would transpose the columns and write the company names beside each date

it would like:

Company 1 2005
Company 1 2006
Company 2 2003
Company 2 2004
Company 2 2002
.
..

so on

thanks in advance