Stacking is where we take two (or more) CSV files and combine the columns, one on top of the other. For example to turn:
The above is easy to do in Easy Data Transform, even if the columns in the two CSV files are different:
The CSV files are now stacked in the vertical order shown on screen. Swap the vertical order of the input items to change the stacking order.
If you want to stack column N of the first table above column N of the second table (regardless of column name), set Align columns by to Column number.
If you want to stack columns by common column header names (even if the columns aren’t in the same order), set Align columns by to Header name. Matching is sensitive to case and white space.
When you are happy with the results output the result into a new CSV file or other format.
If you need to combine a large number of CSV files into one file, you can do it using the batch processing feature. Just set the output file to have Write mode of Append.
Stack is just one of the 53 transforms that Easy Data Transform supports. See our quick start guide for a short overview.
v1.19.1 for Windows 10 / 8 / 7 (37 MB)
v1.19.1 for Mac 11.x to 10.13 (38 MB)
Questions or problems?