2 Ways to Make Group by Same Interval in Pivot Table in Excel

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.

Overview of making group by same interval in Excel Pivot Table


๐Ÿ“ 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.

Dataset for group creating by same interval in pivot table

approach

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.

Inserting Pivot Table

  • 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.

Editing Pivot Table Window

  • Here, select the โ€œTimeโ€ option under the PivotTable Fields.
  • Next, select the โ€œAmountโ€ option.

Organizing Pivot Table

  • 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.

Grouping Time Values

  • Here, from the Grouping window, choose the Hours.
  • Then, hit OK.

Customizing Grouping Option

  • Finally, you will get all your data in target to make a group by the same interval in Pivot Table in Excel.

Creating Group by Time Interval

approach

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.

Inserting Pivot Table

  • 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.

Editing Pivot Table

  • 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.

Organizing 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.

Grouping Range Values

  • Here, from the Grouping window, confirm the start and end range and insert the difference value.
  • Then, hit OK.

Customizing Grouping Option

  • Moreover, you get the amounts as a group within the same interval.

Group Created by Range 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.

Ungrouping Range Values

  • Therefore, you will get the Pivot Table by regrouping.

Ungrouping in Pivot Table


๐Ÿ“„ 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.

(Visited 19 times, 1 visits today)

Tags:

Farihat

Farihat

An Excel enthusiast who wants to share and loves to solve Excel problems. I try to explore available options to guide readers to the maximum ways how they can solve. The world is limitless, and so are the problems in it. Let's help each other to grow. I would love to hear feedback and queries from readers. You can visit my LinkedIn for further information.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo