title: SSRS Column Grouping Based on Row and Column
body: <p>I've looked everywhere but found no luck and did some tinkering which didn't amount to much. I have a table that displays the following result set:</p>
  
  <pre><code>| Name | Value|
  | Pat  | 1.6  |
  | Pat  | 1.4  |
  </code></pre>
  
  <p>I have to group them in together by Row based on the first column (which is not a problem). Although I'm trying to make the report put the two numeric values in one cell in the Tablix.</p>
  
  <p>This is what I need to do:</p>
  
  <p><a href="https://i.stack.imgur.com/YLn9U.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YLn9U.jpg" alt="screenshot"></a></p>
  
  <hr>
  
  <p>And this is what I have achieved</p>
  
  <p><a href="https://i.stack.imgur.com/0V53S.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0V53S.jpg" alt="achieved"></a></p>
  
  <p>I achieved the third one by grouping it by the first column of my result set as a Row group.</p>
  
  <p>Any nudge to the right direction will be very much appreciated!</p>