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.
MS Excel in 2 minutes per week
Like what you’ve learnt above? Get a free 2 minute(or less) video clip once a week via our social media sites.
Easy to subscribe and unsubscribe, this is a good way to see what we can offer.
Learn more on the ‘Excel in 2 minutes’ page or click on the relevant icon to go to your preferred social media platform. The order of video clips release differs for each platform so subscribe to more if you want to learn quicker.