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. Swap the vertical order of the input items in the Center pane by dragging and dropping to change the stacking order. The Excel tables are now stacked in the vertical order shown on screen. Click the Stack button in the Left pane (if it is grey, you haven’t selected 2 or more items to stack).Select the two or more input items you wish to stack using Ctrl+click (PC)/Cmd+click (Mac) (or by dragging a box around them).Drag the input items into the vertical order you want to stack them by dragging and dropping in the Center pane (the top one at the top).A pink input item will be added for each selected sheet with data. Drag the Excel spreadsheets you want to merge onto Easy Data Transform.There is a fully functional free trial and you don’t have to give us your email or sign up to anything.
Install Easy Data Transform on your PC or Mac, if you haven’t done so already.However it is trivial to do in Easy Data Transform: And it becomes a real headache if the columns are differently ordered in the two tables. But that becomes tedious and error prone if there are multiple large tables. Obviously it is easy enough to do the simple example above in Excel using copy and paste. ( You can also merge sheets side-by-side using a common ‘key’ column) Stacking is where we want to take two or more Excel sheets and combine them, one on top of the other (vertically), matching the columns.