0

I have made a simple query that combines data from 4 separate sheets:

=query({'1.MA'!A13:O200;'2.PF'!A13:O200;'3.BM'!A13:O200;'4.C'!A13:O200},"Select * where Col2 is not null ")

The objective is to have all data in the sheets where Column B is filled in. This works for the majority, except for the first 3 rows in the first sheet. The query returns them combined in one row.

All sheets are exactly the same, the error does not reproduce n the first 3 rows of the other sheets.

0
  • try like this:

    =QUERY({'1.MA'!A13:O200; '2.PF'!A13:O200; '3.BM'!A13:O200; '4.C'!A13:O200},
     "select * where Col2 is not null", 0)

  • or like this:

    =QUERY({'1.MA'!A13:O200; '2.PF'!A13:O200; '3.BM'!A13:O200; '4.C'!A13:O200},
     "select * where Col2 is not null", -1)

  • or perhaps like this:

    =ARRAYFORMULA(QUERY(TO_TEXT({
     '1.MA'!A13:O200; '2.PF'!A13:O200; '3.BM'!A13:O200; '4.C'!A13:O200}),
     "select * where Col2 is not null", 0))

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.