Unmerge & Fill Cells

Unmerge selected columns in one or more XLSX sheets and fill data-row blanks with the value above, creating a table that is easier to sort.

Quick start

  1. Upload the XLSX that has merged cells.
  2. Choose sheet, columns and start row, then check the filled values.
  3. Download the result and compare it with the original.

Example

When department and date cells are merged vertically, a filter keeps only the first row of each merged block. Choose those columns to unmerge them and fill the blank cells below with the value above, so all 30 rows carry a department and date. Sorting and filtering then work on every row.

Spreadsheet with department and date cells merged vertically
BeforeA report with department and date cells merged vertically, making filtering unreliable
Spreadsheet after unmerging cells and filling blanks
AfterA 30-row table with merged cells removed and values filled down

Merged cells make sorting and filtering unreliable

Unmerge selected columns in one or more XLSX sheets and fill data-row blanks with the value above, creating a table that is easier to sort.

How to use it

  • Upload an XLSX workbook with merged cells.
  • Choose the sheets, columns, and starting row to process. Check the preview; blank separator rows and formula-only rows are not filled.
  • Download the result and compare it with the original workbook.

Fix a spreadsheet that will not sort or filter

Reports often merge department names or dates across several rows. A filter may keep only the first row and treat the remaining rows as empty; pivot tables can fail for the same reason.

This tool unmerges selected columns and fills data-row blanks from the value above. Blank separator rows and formula-only rows mark boundaries. Review the preview and compare the downloaded workbook with your source.

A visually merged layout is not always a true merged range. Filling genuinely empty cells can spread values where none were intended. Mixed horizontal and vertical header merges need separate cleanup.

What this helps with

  • Unmerge cells and fill each column by hand → Choose sheets and columns, then review the preview.
  • Remembering Excel’s multi-step Go To Special workflow → No special menu sequence is needed.
  • Building a Power Query transformation → Convert a workbook directly in the browser.

Limitations

  • Blank cells that were meant to stay empty may be filled; review the result.
  • Complex multi-row headers with horizontal and vertical merges need separate cleanup.
  • Cell formatting, macros, and charts are not guaranteed to be preserved; keep the original workbook.