Oftentimes, data that you want to analyze is spread across multiple sheets and multiple files. If you want to combine tables found on multiple worksheets and/or multiple worksheets, these four different techniques will help you join them together. Each technique results in different output. Choose the one that works best for you.
These methods are meant for data with like headers and data types.
Four circumstances covered
- Keep Original Order
- Keep the order of the original data by stacking each list.
- Sort the resultant table by any column.
- Duplicates removed
- Remove any duplicate lines of data if you don’t want them in your sample.
- No blank rows
- Remove any blank rows from your new table.
Also, data from another file can be pulled into these formulas using the IMPORTRANGE function.