1

How are discontinuous columns imported? Here, the import is inclusive from B3 to D7 as:

import

Here, the formula is:

=importrange("https://docs.google.com/spreadsheets/d/1GvgMrjtfW2_TBO_stxYdIQMwTo8ODUJTdfUtMIYqqaM/edit#gid=0","data!B3:d7")

Where column C should be omitted. The syntax to omit columns is unknown to me, but I tried:

=importrange("https://docs.google.com/spreadsheets/d/1GvgMrjtfW2_TBO_stxYdIQMwTo8ODUJTdfUtMIYqqaM/edit#gid=0","data!B3:B99,D3:D99")

Something along the lines of:

=QUERY(data!B1:Q,"SELECT B,D")

per the answer from Daniele would probably work, but cannot seem to incorporate that into the import. That query, on its own, does select columns as expected. However, it's seemingly not wired or connected to the worksheet and so isn't dynamic. Query results are static, presumably.

data is here and the import is here.

1 Answer 1

2

Use Query() like this:

=query(importrange("https://docs.google.com/spreadsheets/d/1GvgMrjtfW2_TBO_stxYdIQMwTo8ODUJTdfUtMIYqqaM/edit#gid=0","data!B3:d7"),"select Col1,Col3")
2
  • It doesn't see to let me enter all of that into the cell..? Maybe there's a setting to enable long formula's.
    – Thufir
    Oct 8, 2022 at 3:54
  • 1
    just copy and paste :) you can also resize the formula bar by pulling it down
    – Daniele
    Oct 8, 2022 at 4:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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