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
Bookmarks