The report looks beautiful until you try to sort it.
Merged department names, date blocks, and category headers make a sheet easier to scan. Then someone asks for a pivot table, a filter, or a clean CSV export, and suddenly those merged cells are in the way.
Merge Tools helps with the cleanup step: unmerge the cells and, when needed, fill the split cells with the original value.
The blank-cell surprise
Google Sheets can unmerge cells on its own, but the result is often only half useful. The old merged value usually stays in the top-left cell. The rest of the cells become blank.
That's fine for removing visual formatting. It's bad for analysis.
If "Marketing" covered ten rows before unmerging, those ten rows still belong to Marketing after unmerging. Leaving nine of them blank means filters, sorts, and exports lose context.
Fill while unmerging
Merge Tools lets you split the merged range and copy the original value into each cell that used to be part of that range.
So instead of one visible label and a trail of blanks, every row gets the value it needs. The sheet stops being a formatted report and becomes usable data again.
Where this saves time
Use it when a downloaded report has merged headers but you need to sort by amount, date, owner, or status.
Use it before building a pivot table. Blank category cells make pivots look like the source data is incomplete, even when the original report was only formatted that way.
Use it before sending the sheet into another tool. Most imports expect a rectangular table, not a presentation layout.
Three quick steps
- Open Extensions → Merge Tools.
- Select the merged range you want to clean.
- Choose Unmerge, decide whether to fill split cells with the original merged value, then click Unmerge.
See it in the examples workbook
The Merge Tools — Examples Workbook has an UnmergeFill tab with before-and-after unmerge-and-fill samples.
Related Merge Tools posts
If you are creating grouped reports rather than cleaning them, start with Merge Repeated Values in Google Sheets. For the bigger picture, read Merge Tools for Google Sheets.
Leave a review
If Merge Tools helped you turn a pretty-but-annoying report back into usable data, the Google Workspace Marketplace listing is the place for a short note. Stars and a sentence or two help other people find it before merged cells wreck their next sort.