Equivalent of IMPORTRANGE with script in Google Sheets [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 5 years ago.

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") ; 
  IMPORTRANGE("SheetKey","SheetName3!A2:J")}

I bet I can fix it for you if you can share a copy of your sheets — user0, Commented Apr 24, 2019 at 21:53
Possible duplicate of Small Edit on Import Range Script for Mass Edits on Google Spreadsheets — Rubén - Volunteer Moderator -, Commented Apr 25, 2019 at 0:25
docs.google.com/spreadsheets/d/… Here is a sample dataset with read access. Let me know if it helps, thanks @user0 — aptbs85, Commented Apr 25, 2019 at 8:42
You will have to explain not working as expected in your question; tell us the expected versus actual results. Also, edit that last comment into your question. Questions on SE sites should contain all essential information. Comments can disappear. — user55949, Commented Apr 25, 2019 at 14:09

user0 · Accepted Answer · 2019-04-25 13:57:58Z

0

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

answered Apr 25, 2019 at 13:57

user0

27.1k10 gold badges53 silver badges78 bronze badges

Add a comment |

1 Answer 1