Pro exercise
Pivot monthly values, keeping zeros and gaps apart
Turn long readings into one row per entity with Jan, Feb and Mar columns. A reported zero is not the same as a month nobody reported.
- pivot
- missing values
- type conversion
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.