Question: how to extract data from excel pivot table?
Answer: Select the pivot table by clicking a cell within it. Click the Analyze tab's Select command and choose Entire PivotTable from the menu that appears. Excel selects the entire pivot table range. ...  Copy the pivot table. ...  Select a location for the copied data by clicking there. Paste the pivot table into the new range.