Data Cleaning Exercises

Pro exercise

Checkbox columns to rows

A form stored a multi-select question as one checkbox column per channel. Turn it into one row per respondent and chosen channel; unticked boxes produce no rows.

  • unpivot
  • multi-select
  • normalization

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.