How to convert pivot table into table

How to convert a pivot table into a table

First, insert the pivot table and drag to select the columns , rows, values ​​and other fields, the default style of the generated table is as follows:

Recommended: "Excel Tutorial"

Click the first number in the column cell to expand the table (you can also use PivotTable Tools>Analysis>Expand Fields)

Click PivotTable Tools>Design>Classification Summary> To avoid displaying subtotals, you can remove the subtotal rows in the table

Click PivotTable Tools > Design > Total > Disable rows and columns, and remove the last rows in the table Total row

Click PivotTable Tools>Design>Report Layout>Show in table form and adjust the table to table style

After adjusting the table, all the same items in the first column are empty. To fill in the categories, click PivotTable Tools》Design》Report Layout》Repeat all project labels

At this point, the pivot table has basically become an ordinary table style, and there is only one last step left: cancel the - sign next to the first column of categories, and click the pivot table tool "Analysis" /- button to achieve

The above is the detailed content of How to convert pivot table into table. For more information, please follow other related articles on the PHP Chinese website!