This Will Enable The Pivot Table Wizard, As Shown Below.

On step 2a page of the wizard, click create a single page field for me, and then click next. Select the second option that reads as i will create the. Go back to the workbook and select the cell range, and then back on the pivottable and pivotchart wizard, click add.

In The Next Step, You Will Find Two Options.

Now, select the third option that reads as multiple consolidation ranges and choose the pivot table option from the available options. On step 2b page of the wizard, do the following: On step 1 page of the wizard, click multiple consolidation ranges, and then click next.

Now, Try Pressing The Letter 'P' On The Keypad.