See picture or see this

CodePudding user response：

=ArrayFormula(TRANSPOSE(SPLIT(REGEXREPLACE(TRANSPOSE(QUERY(A2:C&"♦",,10^7)),"(♦ ) |♦$","$1"),"♦ ",FALSE)))

CodePudding user response：

Use filter(), like this:

=filter(A2:A8, len(A2:A8))

See your

Reference:

• Custom Functions in Google Sheets