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