# Merge Sheets

**URL:** <https://community.glideapps.com/t/merge-sheets/3991>\
**Category:** Ask for Help\
**Created:** [January 27, 2020, 12:53am UTC](https://community.glideapps.com/t/merge-sheets/3991 "2020-01-27T00:53:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Imran\_Mohammed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imran_mohammed/32/1123_2.png) [@Imran\_Mohammed](https://community.glideapps.com/u/Imran_Mohammed)\
**Post date:** [January 27, 2020, 12:53am UTC](https://community.glideapps.com/t/merge-sheets/3991/1 "2020-01-27T00:53:37Z")

</div>

Hi, Can you merge 2 sheets in one tab. I am trying to combine 2 sheets with different data sets into one combine list in a new tab.

---

<div class="post-metadata">

**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\
**Post date:** [January 27, 2020, 1:10am UTC](https://community.glideapps.com/t/merge-sheets/3991/2 "2020-01-27T01:10:39Z")

</div>

You can do that with the formula IMPORTRANGE.

[https://support.google.com/docs/answer/3093340](https://support.google.com/docs/answer/3093340)

---

<div class="post-metadata">

**Author:** ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)\
**Post date:** [January 27, 2020, 1:37am UTC](https://community.glideapps.com/t/merge-sheets/3991/3 "2020-01-27T01:37:03Z")

</div>

Like, Francois, I assume you mean different spreadsheets, but if you’re trying to do it from the same spreadsheet, then you could also do it by enclosing your ranges in braces

`={Sheet1!A2:C;Sheet2!A2:C}`

However, the number of columns do need to match I found. So, in the one with less columns, just extend its range to include blank columns.

Or, for a single sheet you still need the braces else you’ll get a value error.

`={Sheet1!A2:C}`

You can also get funky and use sort(). e.g:

`=sort({Sheet1!A2:C;Sheet2!A2:C})`

`={sort(Sheet1!A2:C);sort(Sheet2!A2:C)}`

or just plain old

`=sort(Sheet1!:a2:A)`

Other fun functions are Filter, Unique and Query.