0

When using a query function that selects two columns from another sheet, I get two results in one cell. It looks like it doesn't respect the initial structure of the selected data. Any idea, please?

enter image description here

Improve this question
1
  • your column C is formatted for numbers and also for text
    – user0
    Commented Feb 23, 2019 at 14:29

2 Answers 2

Reset to default
0 

=QUERY(ARRAYFORMULA(TO_TEXT(A1:C6)), "select Col1, Col2 where Col3 !='0'")

enter image description here

Improve this answer
1
  • 1
    From review: This answer was flagged as low-quality because of its length and content.
    – Rubén - Volunteer Moderator - ♦
    Commented Feb 23, 2019 at 23:30
0 

=ARRAY_CONSTRAIN(FILTER(A1:C7,C1:C7<>0),9999,2)

Improve this answer
1
  • 1
    From review: This answer was flagged as low-quality because of its length and content.
    – Rubén - Volunteer Moderator - ♦
    Commented Feb 23, 2019 at 23:29

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.