I want to change horizontal data into vertical. Data set is huge and i would need some VBA help.
My data looks like this -
Customer Product Market Jan/12 Feb/12 Mar/12....
A 1 ox 100 200 50
B 1 nox 30 20 10
and i want the data to look like
Customer product market month
a 1 ox jan/12 100
a 1 ox Feb/12 200
a 1 ox Mar/12 50
b 1 nox jan/12 30
...............
any help will be appreciated.
Thanks
Bookmarks