Unpivotting

The pivot table data structure is a common one, often resulting from the pivot table feature or the QUERY function. However, switching from a pivot table to a standard table is not trivial. There are several ways to unpivot a table, each with its advantages and disadvantages.