Filter & Track Rows

How to filter and track rows for merging?

This article describes how to filter and track rows of data to be merged, when all the rows of data do not need to be merged at once, or to merge rows that were added since the last merge.

Step 1: Click Filter Rows

Click on Filter Rows to create a new column in a Google sheet called Filter Rows to Merge.

Google Docs

Google Sheets

Step 2: Exclude rows from merging

In the Filter Rows to Merge column, type x (or any other text ) in the cells of the rows that need to be excluded from merging.

NOTE: Following the mail merge, the empty cells in the Filter Rows to Merge column are populated with the date/time the merge took place. To merge these rows again, the date/time values need to be deleted.

Advanced Feature: Conditional logic formula to exclude rows from mail merge

Instead of typing x in the Filter Rows to Merge column to exclude rows, a conditional logic formula can be created in the Google Sheets to determine which rows should be excluded. In the example below, rows for employees whose gender is equal to F were excluded from the merge.