Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Pivot the Table

What is a PivotTable, anyways? To Pivot means to move the data from the Rows into the Columns. This is cool.

 

Try it: Pivot the Table!

Click on the PivotTable

Go to the Field List

Drag and Drop the Department Field from the Rows to the Columns.

 

What do you see? The names of the departments are displayed at the top of each column. The count of the Bug Reports, and the name of the software that caused the problems, is shown for each department.