title: LINQ aggregate 30 minute interval to hour
body: <p>I'm not a super expert on LINQ, I've a data below provided by third party:
  Data</p>
  
  <pre><code>Start: 6:00
  End: 6:30
  value: 1 
  Start: 7:00
  End: 7:30
  value: 1
  Start: 8:00
  End: 8:30
  value: 1
  Start: 9:00
  End: 9:30
  value: 1
  Start: 10:00
  End: 10:30
  value: 1
  Start: 11:00
  End: 11:30
  value: 1
  Start: 12:00
  End: 12:30
  value: 1
  Start: 13:00
  End: 13:30
  value: 1
  Start: 14:00
  End: 14:30
  value: 1
  ...
  Start: 05:00
  End: 05:30
  value: 1
  </code></pre>
  
  <p>This data keeps going for a week then 30 days and 365days.</p>
  
  <p>I need to transform each  30minute block in to an hour.</p>
  
  <p>e.g </p>
  
  <pre><code>Start: 6:00
  End: 7:00
  Value: 2
  Start:7:00
  End: 8:00
  Value:2
  ......
  </code></pre>
  
  <p>Assuming that Start, End and Value comes as one row, could someone help how above can be achieved?</p>