Merge Multiple Google Spreadsheets into One Sheet

Question

I have a couple of Google Spreadsheets. This Spreadsheets have the same columns number and columns names, but diffrent data.

I want to merge all of this Spreadsheets into one Sheet. The closest thing i found is this: http://ctrlq.org/code/19980-merge-google-spreadsheets , but it make new Spreadsheet with diffrent Sheet for every Sheets on Spreadsheets. I want just one Sheet with all data. Do you guys have idea how to do that?

Answer 1

Short answer

Use embedded arrays. The simplest form for spreadsheets with regional settings that use dot as decimal separator are

• ={A1:A2;B1:B2} for vertical merging and
• ={A1:A2,B1:B2} for horizontal merging.

Explanation

To merge vertically two ranges,

• for spreadsheets using dot as a decimal separator and comma as function parameter separator

  ={Sheet1!A1:B5;Sheet2!A1:B5}

• for spreadsheets using comma as a decimal and semicolon as function parameter separator

  ={Sheet1!A1:B5\Sheet2!A1:B5}

Reference

• Using arrays in Google Sheets- Google Docs editors Help