To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How to make your first pivot table To start, navigate to Google Sheets and open the spreadsheet you want to work on. This example uses a coin collection because that's more interesting than ...

Figure E Add a calculated column that references a field in another table. You’ll notice that the formula uses the RELATED function to reference the table that isn’t in the active table, Sales.