SQL Server PIVOT operation which rotates a table-valued expression. It turns the unique values in one column into multiple columns in the output and performs aggregations by SUM (), COUNT (), AVG (), ...

Using the OLE DB Provider for SQL Server/Analysis Services, the end-user can connect to a Data Source directly and build a Pivot Table or PivotChart using standard Excel functionality.

I can't seem to get anything to work My table (tbl_Promotions) has 3 columns which I'd like to create the pivot from -Promo_Item (the item name) -Promo_Week (the calendar date of the first Monday) -ID ...