ExcelBanter - Remove grouped items and fields from pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Remove grouped items and fields from pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/176973-remove-grouped-items-fields-pivot-table.html)

Tom Harwell

Remove grouped items and fields from pivot table

When items are grouped a new field with new items are created. Is it
possible to remove them completely without redefining the data source for a
new pivot table?

Tom Harwell[_2_]

Remove grouped items and fields from pivot table

I found that once you ungrouped everything under the new field, the new field
disapeared.

"Tom Harwell" wrote:

When items are grouped a new field with new items are created. Is it
possible to remove them completely without redefining the data source for a
new pivot table?

All times are GMT +1. The time now is 10:10 PM.