title: sql server 2008 - Add a line that counts different values
body: <p>Using SQL Server 2008 I get the following output:</p>
  
  <p><a href="https://i.stack.imgur.com/klq4N.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/klq4N.png" alt="Output"></a></p>
  
  <p>I would like to know if there is a way to sum up, in new lines, all the different texts of Col3 to show something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/cJgej.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cJgej.png" alt="Desired ouptut"></a></p>