I just learned how to use the =query function in Google Sheets, pulling information from one sheet to the next when a specific condition is met.=query('Sheet1'!A:Z, select B, D, E, F, G, I, L where A = 'WON',0)Example:Sheet 1:A AUG  WONB SEPT PENDINGC SEPT LOSTD OCT  WONSheet 2:A AUGD OCTIn the second sheet, I add information in the columns after the ones =query pulled in, for example:A AUG DANNYD OCT NICKYBut when I change the source sheet, from PENDING to WON, it becomes this:A AUG  DANNYB SEPT NICKYD OCTHow do I fix it so whatever information I put in the same row adjusts with the cells it was originally put with, leaving empty cells I can fill out beside the new entries?
Automatically adjust corresponding cells when using =query
google spreadsheets