hello
I need to create a list to convert the data I have into pivot table format.
Below is the form in which i have the data
2009 2010 2011 2012 2013
Tag Q1 Q2 Q3 Q4
Alpha Units
ASP
TAM
SAM
Beta
Gama
.
.
.
This I want to create to the format
Tag Year Units ASP TAM SAM
.
.
.
so that it can be converted to pivot table.
Could someone please guide me on writing a VBA script for this purpose? It can't be done manually because there is a lot of such data. Any help would be appreciated..
Thanks
I need to create a list to convert the data I have into pivot table format.
Below is the form in which i have the data
2009 2010 2011 2012 2013
Tag Q1 Q2 Q3 Q4
Alpha Units
ASP
TAM
SAM
Beta
Gama
.
.
.
This I want to create to the format
Tag Year Units ASP TAM SAM
.
.
.
so that it can be converted to pivot table.
Could someone please guide me on writing a VBA script for this purpose? It can't be done manually because there is a lot of such data. Any help would be appreciated..
Thanks
