Select multiple columns which are not side by side

Question

Select multiple columns which are not side by side

julianofischer opened this issue 4 years ago · 5 comments

Is there a way to select columns like below?
='Sheet1'!B2:B151;'Sheet1'!D2:D151

Answer 1 · 2020-06-20T16:32:54.000Z

sounds good -- Given their APIs, this is either better to do as two queries that you join, or as one query that gets every thing and ignores the "skipped columns" IE:

= Sheet1!B2:D151

drop column C

Answer 2 · 2021-01-02T02:45:22.000Z

Have the same problem

Answer 3 · 2023-03-28T05:17:19.000Z

anyone found any solution for this?

Answer 4 · 2023-03-28T14:14:17.000Z

This is not supported @abedhossainn

Answer 5 · 2024-02-28T14:34:05.000Z

I'm going to close this feature request. The preferred way is to have multiple queries.