"The twists and turns" Excel skill hundred example 11. Simple use of Pivot tables-row and column conversions

Excel PivotTable reports are not only subtotals, but can be easily and quickly converted

For example:

Following the methods in the previous article, we can insert a PivotTable report, put the name in a row, place a course in a column, and put a score in a value:

From the above results, we can see clearly that someone has missed the test of English

What if I only show names with the same name? Is it possible to show the school number as well? Our next article will show you how to display both the school number and the name.

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

"The twists and turns" Excel skill hundred example 11. Simple use of Pivot tables-row and column conversions