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.
You can do that with the formula IMPORTRANGE.
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
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.
You can also get funky and use sort(). e.g:
or just plain old
Other fun functions are Filter, Unique and Query.