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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies