How to turn a pivot table into a normal table

Open pivot table , click the right mouse button, modify the column field names, go to the menu bar on the Layout View, click the report data, select the form form.

Tools / Ingredients: Mechanical Revolution S3 Pro, Windows 10, Excel 2019

1, open the EXCEL form, the form contains a pivot table.

2, select the column field, click the right mouse button, select "Value Field Settings".

3, the pop-up dialog box to modify the display name of the field.

4, select the entire pivot table, click the menu bar on the report data, drop-down selection to the form of table display.

5. The pivot table is displayed in the form of a table.