Pro exercise
Repeated phone columns to distinct rows
A contact form stored up to three phone numbers in phone_1 to phone_3, and people often typed the same number twice. Produce one row per person and distinct phone, remembering the first slot it appeared in.
- unpivot
- deduplication
- multi-valued fields
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.