Equals will allow you to change the output from your queried data and have those changes persist even after refreshing the query.

In order to get started, identify the cell that you would like to modify from your query. You’ll want to select the “Edits and notes” button. To maintain edits to queried data between query runs, you’ll need to select a column that uniquely identifies each row in the data. This is usually an “id” column.

Once you’ve selected the “id” column, you can make changes to the queried output that will persist as you re-run queries. You can always remove data edits by clicking on “Edits and notes” button and selecting the trash can icon. Note: data edits will not write back to your datasource.