Sometimes you’ll have multiple separate ranges or columns or even entire sheets that you’ll want to “stack” on top of each other (i.e. append one or more to another) so that you end up with a single huge master range. Here’s how you achieve this.
Google Sheets Formula to Create a Right Outer Join
Step by step instructions for recreating the equivalent of a (SQL) right outer join in Google Sheets.