Monthly sales arrive as twelve CSV files with identical columns. You need one table containing every month's rows. Which transformation is appropriate?

Published
  1. Pivot the file names
  2. Transpose each table
  3. Append the tables
  4. Merge on Month

Comments — 0