Transpose thing in Google Sheets

Question

I have question about transpose in Google Spreadsheets

I have source and expectation result in my file, maybe you will easily understand after open my sample file

Here is the link : TRANSPOSE SAMPLE FILE

Thank You!

Answer 1

=ArrayFormula(QUERY(SPLIT(FLATTEN(A3:A&"♦"&B3:F),"♦"),"select * where Col2 is not null",0))