How to Pivot Data with Excel Pivot Tables Tutorial
Pivoting data using pivot tables can help you organize data, quickly pivot data and you can look on your worksheet data in several ways. Pivoting can help you analyzing data and getting answers of different questions. You can do different experiments with data to find out new trends and patterns.
In our previous tutorial in which we learned how to create basic pivot table, we used an example to find out answer of question “total sales of all months by each vendor”, now in our new example we will find the answer to question “total sales of all vendors for each month”.
We can do this by simple changing the field in row area.
To change the row
Step 1: Simply click and drag row from row area to the worksheet area to remove that row.
Step 2: Now drag row from right side bar where all fields are shown. Drag row you want to show in pivot table and drop on row tab below, in our example we have used month row. Because we want answer of total sales of each month.
Step 3: That row will immediately show in pivot table. And sales for each month will be shown in pivot table.
This was the method to add and remove rows from pivot table.
To add columns
In our example above pivot table has shown data of one column, if we want to show data of more columns in pivot table we have to add more columns in field’s area.
Step 1: To add column in field area, drag any field you want to show as column in pivot table and drop in field’s area. In our example we want to show details of vendors for each month along with sales.
Step 2: After that you will see that pivot table has been updated and details are being showed in well-mannered way.
In this tutorial we learned how to add and remove rows and add, remove columns to pivot data in a way we want. There are many different and easy ways to pivot data that we will see in our next tutorials. In our next tutorials we will learn filters and slicers.