Merge Tools for Google Sheets: Merge, Unmerge and Combine Cells Without Losing Data
Merge every N cells, merge repeated values, combine cell values with a separator, and unmerge with values filled back in, using the free Merge Tools add-on.
6 chapters · about 22 min · free
Who it is for: Anyone who formats Google Sheets for people to read (rosters, schedules, reports) and then needs the data back in a sortable shape.
What you will learn
- Choose between merging, concatenating and grouping for a layout
- Merge fixed-size blocks with Every N, including the last partial group
- Merge repeated values, or values with the blank cells after them, with By Value
- Combine values with a separator and merge them in one step
- Unmerge and fill every cell with its value so you can sort, filter and pivot
- Turn a raw export into a readable report and back
Before you start
- A Google account with Google Sheets
- Merge Tools installed from the Google Workspace Marketplace (free)
- Optional: the Merge Tools examples workbook (tabs such as EveryN_Vertical, ByValue_Blanks, UnmergeFill, Concat_Vertical)
Chapters
- 01Merge, concatenate or group? Choosing the right layout tool4 min
- 02Merge every N cells4 min
- 03Merge repeated values, or a value with the blanks after it4 min
- 04Concatenate and merge: combine values with a separator3 min
- 05Unmerge cells and fill every cell with its value3 min
- 06Recipe: from raw export to readable report, and back4 min
Frequently asked questions
How do I merge cells in Google Sheets without losing data?
Native merging keeps only the top-left value. With Merge Tools, use Concat to join all values with a separator before merging, or By Value to merge cells that already hold the same value, so nothing is discarded.
How do I merge every 2 or 3 rows in Google Sheets?
Select the range, open Merge Tools → Every N, set the direction and group size, choose whether to merge the last partial group, and click Apply Merge.
How do I merge duplicate cells in a column?
Sort by that column, select it, open By Value, choose Merge repeated values and click Apply Merge. Only consecutive repeats are merged.
How do I unmerge cells and fill the values down?
Select the range, open the Unmerge tab, switch on Copy merged value to every cell and click Unmerge. Every former merged cell gets the value.
Can I combine cells with a comma or new line?
Yes. The Concat tab joins values with a comma, semicolon, pipe, dash, newline or custom separator, optionally trimming whitespace and skipping empty cells, then merges the result into one cell.
Why can't I sort a range with merged cells?
Sheets requires merged cells in a sort range to be the same size. Keep an unmerged data tab for sorting, or unmerge with fill first.
What does 'All columns follow the first' mean?
In By Value, the first column sets the merge pattern and the other selected columns mirror it exactly. Use it when the columns describe the same record.
Is Merge Tools free?
Yes. The Marketplace listing shows it as free of charge.
Is there an example spreadsheet?
The add-on's posts reference an examples workbook with tabs such as EveryN_Vertical, EveryN_Leftover, ByValue_Repeat_Vertical, ByValue_Blanks, UnmergeFill and Concat_Vertical.






