title: Count distinct records in one column with multiple values in another column
body: <p>I'm pretty sure this is an easy question, but I'm having trouble wording it.</p>
  
  <p>I need to count the total number of values in one column based on distinct criteria in another column.</p>
  
  <p>Example:</p>
  
  <pre><code>A CD
  
  B ABC 
  
  C AD
  
  D A
  </code></pre>
  
  <p>Would yield:</p>
  
  <pre><code>A 3
  
  B 1
  
  C 2
  
  D 2
  </code></pre>