How to link two different tables into one?

Question

excel

You need to link two different files with the same structure into one sorted by date.
I found one option on YT: https://www.youtube.com/watch?v=KHm5VbPyuJE
I wrote a formula using it: =query({importrange("KEY";"Registry!A:S");importrange("KEY" ;"Registry!A:S")}; "select * where Col1 is not null order by Col1")
But in the end an error occurs:
Error
The array literal specified in the ARRAY_LITERAL function is missing the values ​​of one or more strings.
Tell me, please, what am I doing wrong?

Answer 1

As a result, the formula worked: =QUERY( { IMPORTRANGE("REFERENCE";"Registry!A3:S"); IMPORTRANGE("REFERENCE";"Registry!A3:S") }; "SELECT * WHERE Col1 IS NOT NULL ORDER BY Col1")