Transpose data in Google Sheets
Transposes data in a Google Sheets spreadsheet.
Common use cases
- Data Manipulation
Application
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | The link (URL) to the Google Sheets spreadsheet | URL | Yes | https://drive.google.com/drive/folders/1Fy55AyJu9vqJ |
| Range start | The end cell of the area to transpose | Text | Yes | A1 |
| Range end | The end cell of the area to transpose | Text | Yes | A6 |
| Result cell start | The specific cell that will contain the transposed contents | Text | Yes | B2 |
| Sheet name | The sheet name where the content to transpose is located | Text | No | Name_sheet |
| Result sheet name | The specific cell where the transposed data will be located. Enter a value when the transposed object is different from the original data location | Text | No | Enter a value when the transposed object is different from the original data location |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data Library. These variables in the Data Library are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
- N/A
Statuses
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the file was successfully transposed onto the specified Google Sheets spreadsheet, and the provided link can be used to directly access the file |
| Unsuccessful | This status is selected in the event of the following scenarios: - Application site is down - Unable to edit the spreadsheet file - The location or sources are not provided - The formula returns as an error |
Requirements
- The provided link to the sheet must have editing permissions.
- All Drives and Sheets need to be shared with: googlewrkbots@wrk.com