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

Occasional Visitor


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

1 Reply



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:


Grouping in PivotTable.png



Hope that helps