You know the spreadsheet is finished when the numbers are right. Then someone says, "Can you make it easier to read?"
That's usually where the tiny formatting jobs begin. Merge these five rows. Group the repeated dates. Split the merged report before sorting it. Join these notes into one clean cell. None of it is hard once. It gets annoying when the same pattern repeats across a whole sheet.
Merge Tools is a Google Sheets add-on for that last-mile spreadsheet work: merge, unmerge, and combine cells without turning the sheet into a hand-edited patchwork.
After installation, open it from Extensions → Merge Tools in any spreadsheet. Select the range you want to work on, then pick Every N, By Value, Unmerge, or Concat in the sidebar and finish with the options and apply the action for that mode.
The kind of problem it solves
Merged cells are useful when the sheet is meant to be read by people. A roster looks cleaner when the same team name is grouped. A printable schedule is easier to scan when each block has room. A report section looks less noisy when repeated labels collapse into one visual header.
But merged cells can also make a mess. They break the rhythm of sorting and filtering. They hide values in a way that makes cleanup harder later. They're helpful until they're not.
Merge Tools sits in that middle ground. It's not trying to turn Google Sheets into a design tool. It's for the practical cases where the grid already has the right data, but the cell structure needs a repeatable rule.
Pick the workflow you need
If the pattern is based on position, start with Merge Every N Cells in Google Sheets. That's the one for "merge every 5 rows" or "merge every 3 columns" without dragging through the range by hand.
If the pattern is based on content, use Merge Repeated Values in Google Sheets. It's better for category columns, repeated dates, department names, statuses, and value-with-blank layouts.
If the sheet came to you already merged and now you need to analyze it, read Unmerge Cells in Google Sheets and Fill Values Automatically. That post covers the cleanup path: split the range, keep the original value, and make the data usable again.
If the cells contain text you want to keep, not discard, use Combine Cells and Merge Values in Google Sheets. That's the Concat flow for notes, labels, names, and summary cells.
Why this deserves separate posts
All four workflows sound similar because they involve merged cells. In practice, they solve different problems.
"Merge every 5 rows" is a layout rule (Every N). "Merge repeated names" is a data-pattern rule (By Value). Unmerge-and-fill is cleanup (Unmerge). Join-then-merge is content transformation (Concat). Lumping them together makes the add-on look like a feature list. Splitting them keeps each post tied to the moment someone actually searches for help.
Try it on a copy
The Merge Tools example workbook has before-and-after sheets for each mode. Use it as a quick sanity check before running the same workflow on a real report.
Leave a review
If Merge Tools saves you from another afternoon of click-merge-repeat, the Google Workspace Marketplace listing is the place for a short note. Stars and a sentence or two help other spreadsheet people find it when merged cells are the thing slowing them down.