Create & use pivot tables – Computer – Docs Editors Help
Posted by jpluimers on 2021/08/02
This was way easier than I thought it would be; it’s just that the meny items are different from Excel: [WayBack] Create & use pivot tables – Computer – Docs Editors Help.
The page has much more, but these are the initial steps:
Add or edit pivot tables
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells with source data you want to use. Important: Each column needs a header.
- In the menu at the top, click Data
Pivot table. Click the pivot table sheet, if it’s not already open.
- In the side panel, next to “Rows” or “Columns,” click Add, then choose a value.
- Note: Sometimes, you’ll see recommended pivot tables based on the data you choose. To add a pivot table, under “Suggested,” choose a pivot table.
- In the side panel, next to “Values,” click Add, then choose the value you want to see over your rows or columns.
- You can change how your data is listed, sorted, summarized, or filtered. Next to what you want to change, click the Down Arrow
.
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment