The PIVOT function of the Google Sheets Query function is extremely useful for summarizing and displaying data. Like a pivot table, it reconstructs and aggregates data, but using the Query function ...