Formatting Data

[joeserrone]

Hello Everyone:
I'm trying to format my data in a specific way, attached is the spreadsheet that contains the initial data and then the formatted template. Sheet1 is the raw data and I need to get it in a format similar to Sheet2.

Any help would be greatly appreciated.

[StephenR]

Have you investigated pivot tables?

[joeserrone]

I did but can't get it to quite look like the template in the second worksheet

[StephenR]

Perhaps you could do the pivot table and then simply copy the data into your template as it should be in the same layout in the PT even if the formatting isn't quite right.