Collapsing row data into individual headings in Pivot Table

aufantastic

New Member
Joined
Sep 8, 2008
Messages
10
I have many categories of data in my pivot table rows. Within each category there are many many days of individual information. I want to collapse all of the daily data into the categories. Is there an easy way to do this without doing each one separately?
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,099,622
Messages
5,469,762
Members
406,668
Latest member
ElizaR

This Week's Hot Topics

Top