Filter & track the rows to merge

From the Google Docs Add-on

Create a column in your sheet and name it whatever you want. Say Filter Rows to Merge. Then type 'x' (or any other text ) for the rows you wish to exclude from merging.

Then open the Options window by clicking the link from the sidebar and set the Filter Rows to Merge column for the Track Merged Rows and Merge Specific Rows options. Click save to apply changes.

As shown in the image below, instead of just typing 'x' to exclude rows, you can even create a formula to determine which rows should be excluded. In this example it is excluding rows for employees whose gender is equal to "F".

NOTE: After a merge takes place, the empty values in the Filter Rows to Merge column are replaced by the date and time the merge took place. To merge these rows again you need to clear/delete the date/time values.

From the Google Sheets Add-on

A column called Filter Rows to Merge will be automatically created for the sheet you want to merge data from. Then type 'x' (or any other text ) for the rows you wish to exclude from merging.

As shown in the image above, instead of just typing 'x' to exclude rows, you can even create a formula to determine which rows should be excluded. In this example it is excluding rows for employees whose gender is equal to "F".

NOTE: After a merge takes place, the empty values in the Filter Rows to Merge column are replaced by the date and time the merge took place. To merge these rows again you need to clear/delete the date/time values.