Stacking is where we want to take two or more Excel sheets and combine the columns, one on top of the other. For example to turn:
Obviously it is easy enough to do the simple example above in Excel using copy and paste. But that becomes a tedious and error prone if there are multiple large tables. And it becomes a real headache if the columns are not identical in the two tables.
However it is trivial to do in Easy Data Transform:
The Excel tables 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 Excel spreadsheet or CSV file.
Stack is just one of the 48 transforms that Easy Data Transform supports. See our quick start guide for a brief overview of what else it can do.
v1.11.2 for Windows 10 / 8 / 7 (50 MB)
v1.11.2 for Mac 11.1 to 10.12 (25 MB)
Questions or problems?