Filter & Track Rows
How do I filter and track rows for merging?
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.
Click Filter Rows.
This will create a new column in your sheet called Filter Rows to Merge.
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.