title: How do I merge rows from a select statement based on conditions
body: <p>Sorry for the vague description, but I'm not sure how to say this.</p>
  
  <p>Here is a sample result from a SELECT statement:</p>
  
  <pre><code>Number      Type      Name
  67          NULL      George
  67          Boy       Kevin
  </code></pre>
  
  <p>What I want:</p>
  
  <pre><code>Number      Type      Name
  67          Boy       George
  </code></pre>
  
  <p>In other words, if Type is null I want to select the Name, but select the Type from the other row.</p>
  
  <p>Hope that makes sense. </p>
  
  <p>EDIT: I was asked in a comment to provide more information. The results above are simplified versions of the results from a much larger and more complex query. Here's a simplified version of that query to match. Also, I'm not asking for code. If I can get a pointer toward the solution, I can figure out the code myself. I'm just not sure which keywords I'm looking for. Thanks.</p>
  
  <pre><code>SELECT DISTINCT Number, [Type], Name
  FROM         MyTable 
  WHERE     Number = 67
  GROUP BY Number, [Type], Name
  </code></pre>