Hi,
I always search in forums for my answer, but in this case I don't know how to search for it, so I might ask for something that is elaborately discussed. What I need is a VBA macro or something that can reshape my table:
company Identifier 2001 2002 2003 a x 1 11 111 a y 2 12 111 a z 3 13 111 b x 4 14 111 b y 5 15 111 b z 6 16 111 c x 7 17 111 c y 8 18 111 c z 9 19 111
To something like this
company year x y z a 2001 1 2 3 a 2002 11 12 13 a 2003 111 111 111 b 2001 4 5 6 b 2002 14 15 16 b 2003 111 111 111 c 2001 7 8 9 c 2002 17 18 19 c 2003 111 111 111
Your help is greatly appreciated as I really need this to fix my thesis (and deadline is running towards me!)
Grtz,
Barbet
Bookmarks