Google Sheets QUERY FORMULA TRANSPOSE

Question

With the formula "QUERY", I want to convert the data in the "IN" table to the "OUT" table. How should I create the "QUERY" formula?

Answer 1

Try this:

=transpose(flatten(query(A2:B4)))

But this can also be done without query.

=TRANSPOSE(FLATTEN(A2:B4))

Reference:

• TRANSPOSE
• QUERY
• FLATTEN