origin_transpose_worksheet
Transpose worksheet rows into columns using an optional label column as new column headers, and write results to a new sheet if desired.
Instructions
Transpose a worksheet so rows become columns.
When label_column is given, that column's values become the new column headers; otherwise headers are R1, R2, .... The original column names become a leading "Field" column. Provide output_book/output_sheet to write to a new sheet instead of in place.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| label_column | No | ||
| book_name | No | ||
| sheet_name | No | ||
| output_book | No | ||
| output_sheet | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||