How can I combine these three rows into one single row with summation of the other columns.

[wadegundy]

I want to combine these three row labels into one row. Add have the sum of G2-G4 in the same row. 

[#2 · Accepted solution]

@wadegundy

You can use PivotTables to do so, but you need to make the instances of the label have the same text.

Take a look at this example below:

Hope that helps