How to Create a Pivot Table in Google Sheets | Scribe

    How to Create a Pivot Table in Google Sheets

    • Alai Umerez |
    • 10 steps |
    • 25 seconds
      1
      Enter the data you want to use for creating a pivot table into Google Sheets
      2
      Select the cells containing the data you wish to analyze, ensuring that you include the column headers
      3
      Click on the "Insert" option in the menu bar
      4
      From the dropdown menu, choose "Pivot table"
      5
      Decide whether you want the pivot table to appear in a new sheet or within the existing sheet For this example, we're inserting the table into a new sheet
      6
      Click "Create" to save the changes made
      7
      Once the table has been created, you can customise it following the suggestions given by Google Sheets
      8
      Or you can choose to drag and drop fields from your dataset into the "Rows," "Columns," and "Values" sections to organize and structure your analysis
      9
      Select the information you wish to add
      10
      Select the desired order for the information and specify how you want the data to be sorted in the table