ysskrishna logoysskrishna

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

Google Sheets Merge Tools
Google Sheets
Google Workspace Add-ons

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

  1. 01Merge, concatenate or group? Choosing the right layout tool4 min
  2. 02Merge every N cells4 min
  3. 03Merge repeated values, or a value with the blanks after it4 min
  4. 04Concatenate and merge: combine values with a separator3 min
  5. 05Unmerge cells and fill every cell with its value3 min
  6. 06Recipe: from raw export to readable report, and back4 min

Start the course

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.

Open the FAQ page

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script
ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Import Markdown, JSON, HTML and CSV tables into Google Sheets without broken columns, and export any range as clean Markdown, JSON, HTML or CSV.

Google Sheets Table Converter
Google Sheets
+1

6 chapters · 16 min

BlogCover image for How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

Google Sheets Tab Manager
Google Workspace Add-ons
+1
2 min read
ProductGoogle WorkspaceGoogle Sheets Text Power Tools

Google Sheets Text Power Tools

Fix messy sheet text in place. Case, trim, strip, and extract without leaving the grid.
Google Sheets Text Power Tools
Text & Data Conversion
Google Workspace Add-ons
Google Sheets
CourseCover image for Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Delete multiple tabs in Google Sheets at once, hide and unhide in bulk, rename with find and replace, colour and sort tabs A–Z with the free Sheets Tab Manager.

Google Sheets Tab Manager
Google Sheets
+1

6 chapters · 24 min