Filter & Track Rows

How do I filter and track rows for merging?

APPLICATION

You have a sheet containing many rows of data but you don't necessarily want to merge all of the rows within the sheet at once.

You want to merge only new rows since your previous merge.

Step 1

Click Filter Rows.

This will create a new column in your sheet called Filter Rows to Merge.

Google Docs

Google Sheets

Step 2

In Google Sheets, in the Filter Rows to Merge column, type x (or any other text ) in the cells of the rows you wish to exclude 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, you will need to clear/delete the date/time values.

Advanced Feature: Conditional Logic Formula to Exclude Rows from Mail Merge

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

Report abuse