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.
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.
2 Likes