title: SQL Combine null rows with non null
body: <p>Due to the way a particular table is written I need to do something a little strange in SQL and I can't find a 'simple' way to do this</p>
  
  <p><strong>Table</strong></p>
  
  <pre><code>Name   Place     Amount
  Chris  Scotland  
  Chris            £1  
  Amy    England
  Amy              £5
  </code></pre>
  
  <p>Output</p>
  
  <pre><code>Chris  Scotland  £1
  Amy    England   £5
  </code></pre>
  
  <p>What I am trying to do is above, so the null rows are essentially ignored and 'grouped' up based on the Name</p>
  
  <p>I have this working using For XML however it is incredibly slow, is there a smarter way to do this?</p>