"We are excited to announce support for PivotTable creation and editing on iPad. PivotTables allow you to calculate, summarize, and analyze data. We have tailored this powerful tool for the iPad's ...
If you are using SQL Server 2005+, then you can use the PIVOT function to transform the data from rows into columns. It sounds like you will need to use dynamic sql if the weeks are unknown but it is easier to see the correct code using a hard-coded version initially. First up, here are some quick table definitions and data for use:
GizChina: Microsoft upgrades Excel for iPad - adds support for pivot tables
MSN: 5 Excel tips you need to know for data analysis using pivot tables
Pivot tables are the unsung heroes of Excel. They transform raw data into actionable insights with just a few clicks. But are you truly harnessing their full potential? Many Excel users only scratch ...
5 Excel tips you need to know for data analysis using pivot tables
Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...
TechRepublic: How to combine and analyze data from multiple data sets using Excel Power Pivot