Hi Guys,
I have a problem with transposing. I have attached the spread sheet below. basically I have some companies with number of members per year running in rows.. ie
here us how it looks now :
Currently :
A _________ B___C
Company1 2001 5
Company1 2003 4
Company2 2001 5
Company2 2002 6
Company2 2003 7
Company2 2004 20
Company2 2005 25
Here is how I want it to look after
___A ________B _____C _____ D _____ E ______ F
_______ 2001____2002____2003____2004____2005
Company1 5 _______ 4
Company2 5 _______6______ 7______20______25
I'm just using underscores to denote spacing since it wont allow me to add too many spaces
I got about 100 companies and any help would be greatly appreciated!!
Thanks
Bookmarks