Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =QUERY({{ARRAYFORMULA(ROW(INDIRECT("A1:A"&COUNTA(QUERY(MY!A2:A; "select A where A is not null")))))QUERY(MY!A2:A; "select A where A is not null")}; {ARRAYFORMULA(ROW(INDIRECT("A1:A"&COUNTA(QUERY(NY!A2:A; "select A where A is not null")))))QUERY(NY!A2:A; "select A where A is not null")}}; "select Col2 order by Col1")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement