Another popular query we have is how to Group and Ungroup for Pivot Tables. This method allows you to combine a number of similar items into a single category for further analysis.
Related: Watch the video clip on how to group and ungroup data in a pivot table
The grouping can be done on text, dates or numbers with each type offering different options. Dates can be grouped into days, months, years, quarters and it even allows for grouping of time. Numbers allows for groups based on the intervals you want. For the text grouping you simply need to choose the items you want grouped together.
In order to do this it is as simple as right clicking on one of the cells and clicking the UNGROUP option.
Next Steps in your Excel journey
Now that you have learnt this, compare your Excel skills to the rest of the world. Below the average Excel Skill Assessment scores from our worldwide audience.
How do your Excel skills compare to your colleagues and work mates? This is a free skills assessment which will help you identify your Excel strengths and weaknesses.