How to add row automatically in between filled row like google form in google spreadsheet?

Question

So, right now I'm working on adding data to my spreadsheet using google form. I would like to add my second google form response below my first google form response automatically by adding row automatically (im doing this process in another sheet using importrange), even in my first google response has some data on it. The content of these two google form remain the same so i would like to see it in 1 sheet.

The reason why i want to do this is to minimize to create another spreadsheet to collect all the data. When im doing this i always get an error message "#REF!" because i know google form using array to add response.

What i want is like this

Can you guys please help me with it? Here is my folder.

Thankyou

Answer 1

You should use the below formula which essentially merges the two different ranges from the two different sheets:

={'Question 1'!A1:B11 ; 'Question 2'!A1:B8}