Google-sheets – How to extract desired text from a cell

A script might be a better way. As far as the formula goes, You can combine both arrays using {}

=ARRAYFORMULA({QUERY();QUERY()})

Problem is that Columns in First query should be equal to Second query or vice versa. Another problem is time taken to import both ranges. If it differs significantly, arrayformula might fail. If the second QUERY is 13 columns, You might need to fill up the other columns with numbers or spaces.

=QUERY(IMPORTRANGE(),"Select Col1,Col2,3,4,5,6,7,8,9,10,11,12,13 where Col1 = 'What' format 3 ';;;' ")

The above formula creates original 2 columns and the rest of 11 columns are filled with corresponding numbers. You can use the format to hide them ( the above code hides number 3 column).

if you need it everything in one cell, try this:

=JOIN(CHAR(10); FILTER(ARRAYFORMULA(Sheet1!B1:B &" "&
                                    Sheet1!C1:C &" "&
                                    Sheet1!D1:D); Sheet1!A1:A=G3))

blank error fix:

=IF(G3<>""; JOIN(CHAR(10); FILTER(ARRAYFORMULA(Sheet1!B1:B &" "&
                                               Sheet1!C1:C &" "&
                                               Sheet1!D1:D); Sheet1!A1:A=G3));)