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

  • your column C is formatted for numbers and also for text – user0 Feb 23 at 14:29
0

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

enter image description here

  • 1
    From review: This answer was flagged as low-quality because of its length and content. – Rubén Feb 23 at 23:30
0

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

  • 1
    From review: This answer was flagged as low-quality because of its length and content. – Rubén Feb 23 at 23:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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