title: SQL Query to concatenate row values based on condition
body: <p>I am in need of concatenating row values based on a condition in SQL
  Consider the following table
  <a href="https://i.stack.imgur.com/DXSo9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DXSo9.png" alt="enter image description here" /></a></p>
  <p>I want to concatenate <code>value(Column3)</code> where the <code>Column1</code> contains <em>&quot;runs&quot;</em> along with <em>&quot;total&quot;</em> and group by <code>Column2</code>.</p>
  <p>My expected output is
  <a href="https://i.stack.imgur.com/ZYFUc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZYFUc.png" alt="enter image description here" /></a></p>