CCleanMySheet

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.

Open the cleaner

Steps

  1. Upload the grouped export
  2. Search fill down
  3. Inspect Diff
  4. 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