CODEWITHSUNDEEP
google-sheetsfiltergoogle-sheets-formulaarray-formulasgoogle-sheets-query
Mahardi Setyoso
Mahardi Setyoso

Reputation: 11

Transpose column of values skipping blank cells in Google Sheets

enter image description herehttps://i.sstatic.net/f2Ztx.png

I need help, for example, I have a condition of thousands of data like in red border and want to form it like in result border

What kind of transpose formula do I have to use? try to figure it out with this formula

=ARRAYFORMULA(QUERY(A3:A&",",,55000))

but still don't find a suitable result

Upvotes: 1

Views: 6090

Answers (2)

K B
K B

Reputation: 23

=TRANSPOSE(FILTER(A3:A, A3:A))

Upvotes: 0

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(SPLIT(QUERY(A3:A,,99^99), " "))

or:

=TRANSPOSE(FILTER(A3:A, A3:A<>""))

Upvotes: 5

Related Questions