Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Table of contents
1.
Introduction
2.
Group Pivot Table Items
2.1.
Grouping of Products
2.2.
Grouping of Dates
3.
FAQs
4.
Key Takeaways
Last Updated: Mar 27, 2024
Easy

Group Pivot Table Items

Master Python: Predicting weather forecasts
Speaker
Ashwin Goyal
Product Manager @

Introduction

MS Excel gives us many features to manipulate our data and represent them in different forms; one of them is pivot tables. A pivot table is a table of grouped values that groups individual items from a more extensive table into one or more discrete categories.

We will learn about the grouping of pivot table items by having a pivot table in this blog.

Reading this blog will enhance your knowledge of MS Excel, and you will know everything about the grouping of pivot table items.

So, don't you want to get a clearer view of data by grouping your items in the pivot table? Let's directly move into the topic.

Group Pivot Table Items

We will see some examples to learn the grouping of pivot table items.

Here you will find one pivot table which we will use in examples-

 

Grouping of Products

In this pivot table, we want to make Group 1 of Apple, Banana, Cherry, and Group 2 of Orange, Pineapple, Watermelon. For creating these two groups, we will follow the below steps-

1. Select Apple, Banana, Cherry in the pivot table.

2. Now, right-click and click on the group button.

3. In the pivot table, select Orange, Pineapple, Watermelon. 

4. Now, right-click and click on the group button.

Note- We can collapse and expand the groups by using the plus and minus buttons beside the group name.

Grouping of Dates

Instead of the Product field, add the Date of Purchase field to the Rows area to produce the pivot table below. There are a lot of entries in the Date of Purchase area: 6-January, 7-February, 22-January, 12-June, and so on.

Execute the procedures below to divide these dates into quarters.

1. Select any cell in the pivot table.

2. Now, right-click and click on the group button.

3. A dialogue box will appear, then select Quarters and click on the OK button.

Result-

Get the tech career you deserve, faster!
Connect with our expert counsellors to understand how to hack your way to success
User rating 4.7/5
1:1 doubt support
95% placement record
Akash Pal
Senior Software Engineer
326% Hike After Job Bootcamp
Himanshu Gusain
Programmer Analyst
32 LPA After Job Bootcamp
After Job
Bootcamp

FAQs

1. What is the advantage of grouping pivot table items?

Grouping data can help you see it more clearly and we can only see the data we want to look at.

2. How to group pivot table items by numbers?

Select the range of cells you want to make a group of. Now, Right-click and select the group option then the grouping dialogue box will appear. Enter the starting, end value, and interval and click on the OK button.

For example, we gave the value of section ‘By’ = 2

Result-

3. What is the other option to group pivot table selected items?

Select the range of cells you want to make a group of. Then click the ‘Group Selection’ button in the ‘Group’ section on the Analyze tab. As a result, the chosen range will be merged into one group.

4. How can we ungroup data?

To ungroup, select the group, right-click, then select ‘Ungroup’ from the menu.

5. How can we change the name of the group?

Select the name and change it in the formula bar to alter a group's name (Group1 or Group2).

Key Takeaways

In this article we have extensively discussed  how to group pivot table items. Furthermore, we learnt how to group products and dates by quarter.

We hope that this blog has helped you enhance your knowledge regarding encryption and if you would like to learn more, check out our articles on Introduction to Excel and Pivot Charts. Do upvote our blog to help other ninjas grow. 

Refer to our guided paths on Coding Ninjas Studio to learn more about DSA, Competitive Programming, JavaScript, System Design, etc. Enroll in our courses and refer to the mock test and problems available. Take a look at the interview experiences and interview bundle for placement preparations.

Happy Learning!

Previous article
Introduction to Pivot Tables
Next article
Multilevel Pivot Table in Excel
Live masterclass