ysskrishna logoysskrishna

Merge Tools for Google Sheets: Merge, Unmerge and Combine Cells Without Losing Data: frequently asked questions

Back to 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.