title: Combine Group Data from duplicate rows into single rows and sums
body: <p>I have searched for an answer to this and I have see how to do this when you have only single lines of data.  I have a report that the data is on 2 lines.  I have looked at pivot tables but it doesn't like multi rows like that.  I need a guiding hand on what direction to look, even if its VBA which I have tried but I am just running into the issue of excel knowing the data is on 2 separate lines.  The first to lines of each are grouped together.  I will highlight in different colors in my example.</p>
  
  <p><img src="https://i.stack.imgur.com/vxAyi.jpg" alt="Image of Worksheet">  </p>
  
  <p>I guess I could have the macro take all the data and combine the two rows into one and then run a pivot table but was hoping I wouldn't have to go to that extreme.  Any help would be great or a point in the right direction to help get me started.  Thanks.  </p>