Is there a way to have the Google Sheets QUERY function's output expand horizontally instead of vertically?

Viewed 1513

When a QUERY function returns more than one result cell it displays them by printing on the next row under the cell where you've written the function. Is there any way to have it print results in the column to the right of the function instead?enter image description here

1 Answers

Wrap your query in TRANSPOSE

Example:

=transpose(query(A1:H8,"select *",1))
Related