Pro exercise
Dates hidden in column headers
A sensor sheet has one column per day, so the dates live in the headers. Unpivot to one row per sensor and day, turn the header into a real date, and drop blank cells (no reading) while keeping zeros.
- unpivot
- headers as data
- dates
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.