Desyncronized lines trying to automate tables
It's a list of names of people who bought a variety of courses
I have a list of registration, which is the base for three of the columns (the ones in the red rectangle)
I used =filter(tablename[column]; tablename[column] <> " ") for those three
I have 12 tables, one for each month, and those first three columns are the same, but the rest isn't and they are too different, even between months, so it can't be automated
The thing is, when a new student comes in, I sort the registration table, and because it's directly on the table, the whole line is sorted correctly, but in the other tables, only the three automated move (obviously)
So, can I somehow link the lines so when person C moves from D3 to D2, the whole line moves with it?
I saw something about power query on excel doing it, but I'm thinking maybe something with query on google sheets can do it?
I've only used query once and it looked very much above my skills