How to group together rows with similar names into a single row

[sam1010]

This is the table. How can I group together similar names into one entry and the count is added for both of them. For example 5-Mock Activity and 6-Mock activity should come in 1 row as "Mock Activity" and count for that field should be 19+5 i.e. 24  

[kamlesh_vaghela]

@sam1010 

Just add this before stats command.

|rex field=environment "\d\s\-\s(?<environment>.*)"

KV 

[sam1010]

yes it's working but the thing is there are many other fields which have similar names for example stage and staging, these two also need to be counted as one "Stage" how to do that?

[kamlesh_vaghela]

@sam1010 

You can replace those value by adding below search after rex command.

| replace "stag*" WITH "Stage" IN environment

KV