ysskrishna logoysskrishna

Chapter 1 of 6 · 4 min

Merge, concatenate or group? Choosing the right layout tool

What merging really does to your data, when to use it, when not to, and a tour of the four Merge Tools modes.

Merged cells make a sheet easier for people to read: a team name spanning its members, a date over its time slots, a section header across a report. They also make the sheet harder for formulas, sorting, filtering and pivots. Knowing which you need saves hours.

What a merge does

When Google Sheets merges cells (Format → Merge cells), the merged block keeps only the top-left value. Sheets warns you when other cells in the selection have values, because they are discarded.

That is the core problem Merge Tools solves: merging the way people want to see it without silently losing values, and getting the values back when you unmerge.

Merge, concatenate, group

WantUseData kept?
One label spanning a block of rowsMergeOnly one value per block, by design
Several values shown together in one cellConcatenate & MergeYes, joined with a separator
Collapse detail rows under a headingSheets' row grouping (select rows → right-click → Group)Yes, untouched
A sortable, filterable tableNo merges at allYes

A good rule: merge only in sheets meant for reading or printing. Keep the source data unmerged on another tab.

The four modes

Open Extensions → Merge Tools. The sidebar shows the selected range at the top (for example Sheet1!A5:C14, with a refresh icon) and four tabs:

TabDescription in the sidebar
Every N"Merge the selection in fixed-size groups along rows or columns."
By Value"Merge repeated values along a column or row, or merge each value with the empty cells below or to the right."
Unmerge"Split merged cells in the selection."
Concat"Join cell values with a separator, then merge into one cell."

Common options on the merge tabs: DIRECTION (vertical down columns or horizontal across rows) and ALIGNMENT (horizontal left/center/right; vertical top/middle/bottom).

Step by step: first look

  1. Install Merge Tools from its Marketplace listing.
  2. Open a sheet, select a small range, open the sidebar.
  3. Check the range shown at the top matches your selection. If you change the selection, click the refresh icon.
  4. Click through the four tabs and read each description.

Before you merge anything

  • Duplicate the tab, or practise in the examples workbook.
  • Decide which tab is for reading and which is for data.
  • Merging inside a range you later sort will block the sort ("all merged cells need to be the same size").

Worked example: pick the right tool

Each row below is a real request type. Decide which tool fits before reading the answer column.

RequestRight toolWhy
"Show each department once, spanning its rows"Merge (By Value, Merge repeated values)Same value repeated down a column; you want one visible label
"Put all of a customer's tags into one cell"Concat (Concatenate & Merge)Several different values must survive in one cell
"Let me collapse the Q1 rows while I read Q2"Native Sheets row grouping (no merge)You want to hide rows, not change cells
"Each 3-row block is one time slot"Merge (Every N, group size 3)Fixed-size blocks regardless of content
"This downloaded report won't sort"Unmerge, with "Copy merged value to every cell" onMerged cells block sorting and filtering

Common mistakes

  • Merging in the data tab. A merged cell keeps only the top-left value, and formulas such as VLOOKUP, QUERY or a pivot table that read the range afterwards see blanks in the other rows. Merge a presentation copy, keep the raw data unmerged.
  • Treating merge as "combine". If you need both "Core" and "Web" to survive, a merge is the wrong operation; use Concat.
  • Merging before sorting. Sheets refuses to sort a range that contains merged cells of different sizes, so sort first, merge last.
  • Forgetting alignment. A tall merged cell with default bottom alignment reads as if the label belongs to the last row. Set Vertical alignment to Middle in the sidebar before you click Apply Merge.

If you only remember one rule from this chapter: merge is a display decision, made at the end, on a copy.

Quick check

  1. What does a native Sheets merge keep?Only the top-left value of the block.

  2. You need to show three emails in one cell. Merge or concatenate?Concatenate (Concat tab), so all three values are kept.

  3. Where should merges live?In sheets meant for reading or printing, not in the data you sort and filter.

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