XLMind Data · Clean

Fill Blanks

Fills each blank cell in your selection with the value from the cell above it.

What it does

Fills each blank cell in your selection with the value from the cell above it. This is useful for flattening grouped reports before you build a PivotTable. Select the columns that have the gaps first. Only truly empty cells are filled and you can undo the change.

Your data is processed on your own computer. Your Excel contents are never shared with AI services.