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 by step instruction to create a pivot table. Start Microsoft Excel 2007 and open a new document. On the Insert tab, click the PivotTable button in the Tables group. The 'Create PivotTable' wizard appears.Choose one of two options under 'Choose the data that you want to analyze': Select a table or range. This option requires the data to be available in the current Excel workbook.Since you started with a new document in step 1, you first need to import the data from the PMPRO_PIVOT.CSV data source file.hen, after the data has been imported: Select the first column in the first line of the imported data. On the Insert tab, click the PivotTable button. The 'Create PivotTable' wizard appears. The Select a table or range option is already selected, and the Table/Range is automatically inserted by Excel.