title: SQL: Combine value into one result when NULL or empty
body: <p>I have a SQL query that returns two columns - "Title" and "Count".  When "Title" is NULL or empty (''), I want to combine the result into one row.  How can I do this?</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>SELECT  [Title] WHEN '' THEN 'blank' ELSE ISNULL([Title],'blank') AS [Title],
          COUNT([value]) AS [Count]
  FROM ....
  WHERE ....
  GROUP BY [Title],[Count]
  </code></pre>
  
  <p>but because of the Group By, they are split into two different rows:</p>
  
  <p><img src="https://i.stack.imgur.com/8dzde.png" alt="enter image description here"></p>