Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to ungroup dates in an Excel pivot table?

Sometimes the dates will be automatically grouped by month when you add the Date field as row label in a pivot table as below screenshot shown. But you may need to ungroup the dates in the pivot table occasionally. Here, this article you will show the easy solution.

Ungroup dates in an Excel pivot table

Easily groups cells and calculate by values in another column in Excel

With Kutools for Excel’s Advanced Combine Rows feature, you can quick group all cells of one column based on values in another column, or calculate (sum, count, average, max, etc.) these cells by the values in another column at ease! Full Feature Free Trial 60-day!
ad advanced combine rows group

Enable you to do smarter, faster and better

Kutools - the best office productivity tool brings 300 advanced features to Excel. Details... Download...

Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...



Ungroup dates in an Excel pivot table

If the dates are grouped in the Row Labels column of a pivot table, you can easy ungroup them as follows:

Right click any date or group name in the Row Labels column, and select Ungroup in the context menu. See screenshot:

Now you will see the dates in the Row Labels column are ungrouped. See screenshot:


Related articles:



Excel Productivity Tools

Kutools for Excel - The Best Office Productivity Tool

  • Brings 300 powerful advanced features to Excel, enable you to do smarter, faster and better.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Office Tab - brings tabbed interface to Office, make your work much easier.

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.