What is grouping and un-grouping in MS Excel

What is grouping and un-grouping in MS Excel?

As the name of this grouping means a large data will be grouped
Based on some values . That value will head of the related data.

Example:-

In given example you will see that we have some country with some state
And we want to see all state in group with related country then we apply grouping
On country.

How to apply grouping in excel?

Below steps are given. All steps are also shown in given gif example.

Step1:-Click on DATA tab.
Step2:-Select all column and row of data.
Step3:- Click group data button.
Step4:- A  window will be open then select row and click ok.
Step5:- There are 3 options. Group and ungroup and subtotal.
Step:6:- Click sub total button to set criteria of count and summation of grouping data.

All above steps are shown in below GIF image:-