Move dimension
The Google Sheets Move Dimension tool enables users to seamlessly move rows or columns within a spreadsheet, optimizing data organization and workflow efficiency. It leverages the Google Sheets API to reposition selected dimensions precisely as needed.
Features
- Supports moving entire rows or columns within a spreadsheet.
- Allows selection of specific ranges using start and end indices for precise repositioning.
- Integrates with Shared Drives and My Drive for flexible source selection.
- Automatically shifts existing data to accommodate moved dimensions without data loss.
- Utilizes zero-based indexing for accurate dimension placement before removal from the original location.
Benefits
- Enhances spreadsheet data management and organization with ease.
- Saves time by automating manual cutting and pasting operations in Google Sheets.
- Reduces errors by providing precise control over dimension movement.
- Improves collaboration by supporting both personal and shared drive spreadsheets.
- Streamlines complex spreadsheet restructuring tasks for better productivity.
Description
Move a dimension in a spreadsheet. See the documentation
Parameters
6 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-move-dimension, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-move-dimension, propName: sheetId. |
| dimensionrequired | enum | The dimension to move |
| startIndexrequired | integer | The start (inclusive) of the span |
| endIndexrequired | integer | The end (exclusive) of the span |
| destinationIndexrequired | integer | The zero-based start index of where to move the source data to, based on the coordinates before the source data is removed from the grid. Existing data will be shifted down or right (depending on the dimension) to make room for the moved dimensions. The source dimensions are removed from the grid, so the the data may end up in a different index than specified. For example, given |