Farihat
Organizing data using various techniques is quite common in Microsoft Excel. Records are arranged in a tabular form here. There are a variety of data that can easily help in analyzing. For that comfort, you can make a group by the same interval using the Pivot Table feature in Excel. The methods might be lengthy for you to follow step by step. But, it will ensure better representation than any other alternatives. It applies to both adjacent and non-adjacent columns and you can eventually modify it according to your requirements. All the methods have step-by-step instructions with a figurative description.
📁 Download Excel File
Download the Excel file below.
Learn to Make Group by Same Interval in Pivot Table in Excel with These 2 Approaches
The article is going to introduce two ways to make a group by the same interval in a Pivot Table in Excel. The following discussion will cover the uses of the Pivot Table feature in two ways: one by time interval and the other by range interval. Therefore, users will get a walkthrough of these solutions. You will find a dataset to modify in the following methods below to help you understand.
1. Creating Group by Time Intervals
In order to make a group by the same time interval in the Pivot Table in Excel, you need to group given time values by hours. The hour option helps to remove the minute-second variations. Eventually, the grouping option based on Pivot Table works efficiently. See the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- To begin with, select the data range B5:D9.
- Now, select the Pivot Table icon from the Insert tab.
- Next, Excel will show you the PivotTable from table or range window.
- After that, choose the Existing Worksheet option and select cell B11 as the location.
- Then, click on OK.
- Here, select the “Time” option under the PivotTable Fields.
- Next, select the “Amount” option.
- Now, you will find your required Pivot Table.
- Here, choose any of the cells within the time column and right-click on it.
- After that, click on the Group option from the Context Menu.
- Here, from the Grouping window, choose the Hours.
- Then, hit OK.
- Finally, you will get all your data in target to make a group by the same interval in Pivot Table in Excel.
2. Making Group by Range Intervals
In order to make a group by the same range interval in Pivot Table in Excel, you need to group given values by ranges varying in a specific difference. Eventually, the grouping option based on Pivot Table works efficiently. This method is mostly used in statistics. See the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, select the data range B5:D9.
- Next, select the Pivot Table icon from the Insert tab.
- Then, Excel will show you the PivotTable from table or range window.
- After that, choose the Existing Worksheet option and select cell B11 as the location.
- Then, click on OK.
- Here, drag the “Time”, “Type” and “Amount” options to the Values, Rows, and Columns fields respectively under the PivotTable Fields.
- Next, select the “Amount” option.
- Then, you will find your required Pivot Table.
- Here, choose any of the cells within the amount row and right-click on it.
- After that, click on the Group option from the Context Menu.
- Here, from the Grouping window, confirm the start and end range and insert the difference value.
- Then, hit OK.
- Moreover, you get the amounts as a group within the same interval.
How to Ungroup in Pivot Table
You can now easily make a group by the same interval in Pivot Table in Excel. Now there are cases when you need to ungroup the grouped data in a Pivot Table. For that process, we considered the dataset of 2nd method to ungroup. See the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- First, choose any of the cells within the amount row group and right-click on it.
- Second, click on the Ungroup option from the Context Menu.
- Therefore, you will get the Pivot Table by regrouping.
📄 Important Notes
🖊️ If the Pivot Table Customization option is unavailable, you can always get it from the Insert tab.
📝 Takeaways from This Article
The article lets the readers understand the variety of options available to make a group by the same interval in a Pivot Table in Excel.
📌 Primarily, you can create a group by using the same interval in case of time variations.
📌 You can also try range variation to make a group by the same interval through the column or row in the Pivot Table in Excel.
Conclusion
To make a group by the same interval in the Pivot Table in Excel, you can use the Pivot Table feature in two ways; one by time interval and the other by range interval. In case of further queries, readers are requested to leave a comment for the author. The author will try their best to come up with a suitable solution. Follow ExcelDen to get more access to solutions regarding your Excel problems.
