To shrink the wax remnant from the sides of the glass initially, you can also put the candle in the freezer for a few hours.
Example 2: Group a Pivot Table by Range. Imagine you have created the pivot table on the leftshown above, which groups 150 children according to age. The ages range from 5 to 16 years. If you want to group the ages into the age ranges 5-8 years, 9-12 years and 13-16 years, you can this as follows: 1  Right click on left column of the pivot table (containing the ages) and select the option Group...; 2  You will be presented with the 'Grouping' dialog box for numbers;
Step 2 â Uncheck the âSave source data with fileâ and âEnable show detailsâ from pivot table options. Step 3 â Create a new named range of your existing data source (Select your existing source data range and give it another name to create a new named range).hen you make copies pivot table/charts (straightforward copy/paste) and edit the grouping/fields of the copied table you would notice the original/source table also changes inline with the copied table/chart. Some blogs suggest the following steps: 1  make a copy of your pivot table.