String / Array Transformation (Practical)

Question

## Problem

Parse and transform structured input (e.g., normalize records, dedupe, and reshape) — Zapier's practical, real-world style.

## Example
```
messy records -> normalized, deduped output
```

## Constraints
- Handle malformed input gracefully

## What Zapier looks for
Good code beyond puzzles: clear structure, edge cases, and tests. You may use any resources, as on the job.