Combine rows of varying length google sheets

Question

How can I combine rows of varying length like above?

I want a function, that can combine rows 1-4 and end up with one row with all the values like row 6

Answer 1

use:

=TRANSPOSE(QUERY(FLATTEN(A1:C4); "where Col1 is not null"; 0))