CleanMySheet guide
Fill missing values from the row above
Fill missing down copies the last non-blank value into following blanks, per column, skipping locked columns. Useful when Excel exports repeat a category only on the first row of a group.
Fill-down waits in Review. Sparse blanks stay put.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Upload the grouped export
- Search fill down
- Inspect Diff
- Export
Not interpolation
Numeric gaps are not linearly interpolated in this version. Fill-down is last-observation carried forward only.
Related searches this page answers
- fill down excel online
- forward fill csv
- ffill spreadsheet