I want to combine these three row labels into one row. Add have the sum of G2-G4 in the same row.
View best response
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