There is no need to change T-SQL script. All you need to do is this: 1. Click inside of the results (pivot table) so that the pivot table list is visible. If it is still not visible then right-click and pick "**Show Field List**" from the popup menu. 2. Drag the fields from the "**Row Labels**" area to the "**Column Labels**" 3. All the fields which you currently have in the **Values** are are also present in the "**Column Labels**", they are now denoted as **Σ Values**. So, drag the **Σ Values** from the **Column Labels** to the **Row Labels** The above procedure will transpose rows to columns and vice versa. Hope this helps. Oleg
19 People are following this question.
