How to combine data from different tabs into a single list in Google Sheets

If you work with spreadsheets and haven't needed to combine data from different tabs yet, it's coming so you should know how to handle it. Data isn't always as clean as we need it to be so it's important to understand how to manipulate the data into a workable format for our needs.

Here are 4 ways to combine data from different tabs. Two ways to combine the data, and two ways to exclude those pesky blank rows that cause chaos.

Combine Data:
VSTACK
Curly Braces

Exclude blank rows:
Filter + (one of the above)
Query + (one of the above)

Once you master these, you'll be able to format data however you need to build formulas off of a single data set.

00:00 - Intro
00:00 - VSTACK
00:50 - Curly Braces
01:29 - FILTER
02:10 - QUERY
02:50 - Outro