"The twists and turns" Excel skill hundred example 12. Classic Pivot Table layout

In the above we have the following pivot table:

1. We also dragged the study number to the line and placed it above the name

Although both the display and the number also show names, they are not on the same line

2. Click on the Row tab, right, select "Pivot table Options"

3. Click on the "Show" tab and select "Classic pivot table layout" below.

4. When click OK is selected, we can see the following effect:

Although the school number and name on the same line, but there is a summary, it seems that the effect is disorderly.

5. Re-select the secondary school number, right-click, remove the previous tick in the subtotal

6. We can also copy the values and paste them as numeric values, then we can adjust the formatting accordingly.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

"The twists and turns" Excel skill hundred example 12. Classic Pivot Table layout