title: SSRS sort columns
body: <p>I have some data which looks like this</p>
  
  <pre><code>ID   |Name  | Label1| Data1 |L2 |D2 |L3 | D3|
  AAAA | C    | X     | 2     | Y | 4 |   |   |
  BBBB | D    | Y     | 5     | Z | 6 |   |   | 
  CCCC | E    | X     | 3     | Y | 6 | Z | 9 |
  DDDD | F    | Z     | 5     | X | 6 | Y | 3 |
  </code></pre>
  
  <p>And I need to display it on a report like so: </p>
  
  <pre><code>ID   |Name  | X | Y | Z | 
  AAAA | C    | 2 | 4 | 0 |
  BBBB | D    | 0 | 5 | 6 |
  CCCC | E    | 3 | 6 | 9 |
  DDDD | F    | 6 | 3 | 5 |
  </code></pre>
  
  <p>How do I go about doing this? </p>