The pivot table in a spreadsheet is used to summarize the data set for analysis purposes. It converts the vast data set into tabular form, which is simple to understand. Pivot tables can be used to view the data set from several aspects. In addition, using the provided suggestions, one can make pivot tables for the first time. Let’s look at how to make pivot tables in a few easy steps.
1. Select the set of data
The data for air conditioners sales in North and South India are there in screenshot 1.The divisions are further divided into different states in North and South India, and for each product, information on the units sold and the price per unit is provided.
Screenshot 1: Our initial data set
Select the data set you wish to turn into a tabular format ; in this case, we are picking A1 through E15. By selecting the entire data set, a pivot table will be built around it.
Screenshot 2: Select data
2. Inserting the pivot table
Once the data set has been chosen, click on Insert to bring up the drop-down menu where you may choose a pivot table. Click on Pivot to proceed to the next panel, and screenshot 3 is provided for reference.
Screenshot 3: Insert Pivot table
When you choose Pivot Table, a new panel displaying Create Pivot Table in New Sheet appears on screenshot 4. Select Create Form here to continue to the table area.
Screenshot 4: Select “New sheet”
3. Obtain a table from suggestions
In screenshot 5, there are suggestions for creating tables; if you want to create your own version of the table with different aspects, you can add rows and columns with values.
Screenshot 5: Select “Average of Price per unit for each subdivision”
Screenshot 6 shows a table that was generated automatically by choosing from options.
Screenshot 6: Pivot Table 1
4. Edit to obtain the required table
In order to create a pivot table, click the add from rows option. A drop-down menu containing various options from the data set will then appear; click any of them to build a table around it.
Screenshot 7: Edit Pivot Table
Similarly, you may add more rows by selecting the add option. In this instance, we’ve created a pivot table that includes sales information for air conditioners in North and South India, with the subdivisions’ divisions framed and listed separately. See screenshot 8.
Screenshot 8: Pivot Table 2
5. Add values into pivot table
You can enter data into the values format using the values option, which will result in the creation of a new row and a total of figures. screenshot 9 can be followed.
Screenshot 9: Pivot Table Example 3
Finished pivot table
Included here an example link to the produced table here for your convenience- Pivot Table