SSRS Report, How do I have Group By on the Columns <p>In MS SQL 2008 R2 DB, I have a table:</p> <pre><code>Name, Value, Type A, 1, T1 B, 2, T1 C, 3, T1 D, 4, T1 A, 10, T2 B, 20, T2 C, 13, T2 D, 45, T2 A, 11, T3 B, 22, T3 C, 33, T3 D, 44, T3 </code></pre> <p>What I want to do is to get this:</p> <pre><code>Name, Type T1, T2, T3 A, 1, 10, 11 B, 2, 20, 22 C, 3, 13, 33 D, 4, 45, 44 </code></pre> <p>From the query, I can return this: Name, Value, Type A, 1, T1 B, 2, T1 C, 3, T1 D, 4, T1</p> <pre><code>A, 10, T2 B, 20, T2 C, 13, T2 D, 45, T2 A, 11, T3 B, 22, T3 C, 33, T3 D, 44, T3 </code></pre> <p>Now I want to take this data and in SSRS, transform it into this form:</p> <pre><code>Name, Type T1, T2, T3 A, 1, 10, 11 B, 2, 20, 22 C, 3, 13, 33 D, 4, 45, 44 </code></pre> <p>Types can change from one execution to another.</p>