unpivot_range
Unpivot wide spreadsheet data into normalized rows, converting column headers into variable-value pairs for analysis.
Instructions
Convert a wide range into normalized rows and write the result.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id_columns | Yes | ||
| source_range | Yes | ||
| target_range | Yes | ||
| spreadsheet_id | Yes | ||
| skip_empty_values | No | ||
| value_column_name | No | value | |
| variable_column_name | No | variable |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||