Users are now able to perform 2 types of transformations on their spreadsheet data:
- Pivot: Expand values within a column to their own columns
- Unpivot: The opposite of pivot - condense multiple columns back into 2 columns.
Pivoting is helpful if you'd like to drill down deeper within a specific category of data.
Unpivoting is helpful to graph an overall picture of your data. For example, sometimes online survey results break out each question into its own column. Using unpivot, you can condense multiple question columns into just two: Question & Response. This will help you graph an overall response (if all of the responses are in the same format)