Pivot Tables in Google Spreadsheets!

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.

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.

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.

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.

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 6 shows a table that was generated automatically by choosing from options.

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.

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.

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.

Included here an example link to the produced table here for your convenience- Pivot Table