title: LINQ Merging results in rows
body: <p>I have a LINQ query which returns a set of rows. The structure is:</p>
  
  <pre><code>NAME,    col1, col2, col3, col4
  name1     1    null  null  null
  name1    null   1    null  null
  name1    null  null   1     1 
  </code></pre>
  
  <p>As a result I want to have one row containing</p>
  
  <pre><code>name1     1     1     1     1
  </code></pre>
  
  <p>So I want to group those results by name and merge (sum?) the other columns so if I have not null in one of the rows in a column - I will receive anything except null.</p>
  
  <p>Thanks for help!</p>