I have the following
=query(XX!A2:A;" select A where A>'50' ")
=query(YY!A2:A;" select A where A>'50' ")
how do I combine these two data sources so I don't have to have two separate columns they process data to?
- best would be if the 1st row from
XXis followed by the 1st row of
YY, 2nd row followed by 2nd row... and so on
- If the above option is not easily possible, it is OK for one query to be followed by the second one (if I expect correctly that the start of the second will be moved with newly added data into the first one)