Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script?

={IMPORTRANGE("SheetKey","SheetName1!A:J") ; 
  IMPORTRANGE("SheetKey","SheetName2!A2:J") ; 

closed as unclear what you're asking by Rubén, serenesat, jonsca Apr 26 at 2:23

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


=QUERY({'AW Data'!A1:J; 'Facebook Data'!A1:J; 'Bing Data'!A1:J}, "where Col1 is not null")


  • 1
    Wow this is great I really appreciate it. A million thanks! Cant find a way to mark this as the right answer though – aptbs85 Apr 25 at 14:20
  • @aptbs85 you have that option! just click here: i.stack.imgur.com/prjBr.png – user0 Apr 25 at 18:50

Not the answer you're looking for? Browse other questions tagged or ask your own question.