I have a master sheet with data and another table that filters values through the query function. In the table with the query values there is a column that is completed manually, that is, values are added does not depend on the query. The problem is that when you refresh the data in the master sheet and add new rows, the query executes and the values are moved, moving values to other positions.
The idea is that when updating these values they remain related to the data and that the new lines of the master sheet are added but without altering the data.
I use this query:
=QUERY(‘MATRÍCULAS 24-25’!A:S;”SELECT A,B,C,D,E,L,F,O WHERE L=’1º Educación Secundaria Obligatoria (LOMLOE)'”;1)
In this File i added one extra column and added fixed values to students, but when update the datasource add new rows and move values. can i fix?
Thanks