CODEWITHSUNDEEP
google-sheets
Ralnor
Ralnor

Reputation: 43

Stack result of Query in a single row

My question is - How to transpose N x M query result to single row where order is as follows

Input table

Col1Row1 Col2Row1 Col3Row1
Col1Row2 Col2Row2 Col3Row2

To

Col1Row1 Col2Row2 Col3Row1 Col1Row2 Col2Row2 Col3Row2

Upvotes: 0

Views: 35

Answers (1)

basic
basic

Reputation: 11968

Use FLATTEN:

=TRANSPOSE(FLATTEN(A1:C2))

enter image description here

Upvotes: 1

Related Questions