There are two major ways to merge Excel spreadsheets: Joining rows horizontally (side-by-side) and Stacking columns vertically (one on top of the other).
For example, joining is where we want to take these two tables:
And merge the rows side-by-side using a common (‘key’) column to get:
For example, stacking is where we want to take these two tables:
And merge matching columns one on top of the other to get:
Questions or problems?