Transpose Data using SQL query

Hi,

I got a file which has Template name and numbers for it.It takes me around 2 HOURS to prepare data by using pivot table and pasting values using transpose. If anyone can provide a macro to perform this task quickly that would be great.

I have attached the raw data under tab DATA, Output which I am looking for under "Output" tab.And Calculation is there under calculation tab.I have done the calculation of one Template name "aa20150330" and shown the output also.Can I export this data into Ms Access and run query to do this task. I know SQL query very well.


Thanks

Loving

If you are using ACCESS , then use a CROSSTAB query. (use the query wizard to build it)

If the data is in Excel, then record a macro to build the Pivot table (or a Transpose). Make your changes in the macro.