How to use query + importrange to merge spreadsheets?

QUERY + IMPORTRANGE formula syntax to merge spreadsheets vertically: data_range must contain the same column range for each spreadsheet_url, whereas the number of rows may differ. IMPORTANT: Before importing data from multiple spreadsheets, you’ll have to make data imports from each spreadsheet separately to allow access.
For More Information Please Refer:

You May Also Like to Read: