# Spreadsheet script test packet
Fictional teaching material. No generated script has been tested or supplied.

## Input
| ID | Name | Email |
| --- | --- | --- |
| A01 |  Robin Example  | robin@example.com |
| A02 | Casey Example | |
| A01 | Robin Duplicate | duplicate@example.com |
| A03 | Casey Example | casey@example.com |

## Required behavior and answer key
Preserve Input. Trim outer spaces from names. Keep first exact ID occurrence in Review; put subsequent occurrences in Duplicates. Do not merge names. Leave missing email blank. No mail, external requests or triggers.
Review: A01 / Robin Example / robin@example.com; A02 / Casey Example / blank; A03 / Casey Example / casey@example.com.
Duplicates: second A01 / Robin Duplicate / duplicate@example.com.
Rerun: same result, no appended duplicates.
Missing Input: stop with a clear error, no plausible empty success.
Missing ID: define and approve a handling rule before execution.

## Review record
Code version:
Reviewer:
Permissions requested:
First run result:
Repeat run result:
Failure check:
Owner and recovery steps:
