title: How to merge SQL rows with null values
body: <p>I have many rows for the same data but each row has a different columns populated. I want to join all these rows into a single row. I have tried group by, but the dataset has 1000 columns. Any suggestions?</p>
  
  <pre><code>SELECT TOP 100 * 
  FROM [Hilltopsamplerfix].[dbo].[tempHilltopWaterQualityExtractPivot]
  WHERE [SiteName] = 'site' AND [RunDate] = 'xxx'
  </code></pre>
  
  <p>Example of the data</p>
  
  <p>I can't paste an image because my reputation is under 10</p>
  
  <pre><code>+------------------------------+
  | Site column1 column2 column3 |
  +------------------------------+
  | SITE1 NULL   NULL    76      |
  | SITE1 NULL   23      NULL    |
  | SITE1 NULL   NULL    NULL    |
  +------------------------------+
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>+------------------------------+
  | Site column1 column2 column3 |
  +------------------------------+
  | SITE1 NULL   23      76      |
  +------------------------------+
  </code></pre>