title: How to Aggregate QuerySet for Arbitrary Keys Group By
body: <pre><code>&lt;QuerySet [
      {'id': 520, 'Commission': None, 'Effective Date': '2019-12-11 00:00:00+00'},
      {'id': 520, 'Commission': 30, 'Effective Date': None}
  ]&gt;
  </code></pre>
  
  <p>Suppose I had a Django QuerySet like the above, with an arbitrary number of matching keys where only one is expected to not be null per key.</p>
  
  <p>How do I get a result like the following per <code>id</code> as if I'm grouping by <code>id</code>?</p>
  
  <pre><code>&lt;QuerySet [
      {'id': 520, 'Commission': 30, 'Effective Date': '2019-12-11 00:00:00+00'}
  ]&gt;
  </code></pre>