remove_duplicates
Delete duplicate rows from a range, keeping the first occurrence. Specify columns for uniqueness comparison or compare entire rows; optionally preserve the header row.
Instructions
Delete duplicate rows within a range, keeping each first occurrence.
columns lists the sheet column letters that decide uniqueness, e.g. ["A","C"] (each must fall inside the range); omit to compare whole rows. Text comparison ignores case, like Excel's Remove Duplicates. Set has_header=true to leave the range's first row in place. Remaining rows shift up and the freed rows at the bottom are cleared. Only values are compared and moved, not formatting.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| columns | No | ||
| has_header | No | ||
| session_id | Yes |