Stack Rows

Stack Rows is use to combine data in horizontal and vertical direction. The illustraion are given for both vertical and horizontal stacking.

Stack Rows - Vertical

In vertical stacking, the data is stacked one below another, therefore, the user need to make sure that the data in all the stacks is formatted column-wise, so that after stacking the final table will contain sensible data.

Sample Data

We have sample data from three different sources. We will use the vertical stack rows to create a combined table.

Step 1

Click on the Stack Rows command under SheetKraft tab.

Step 2

A window will appear, then select the data manually for Selection 1 by clicking the marked tab in screenshot below.

Step 3

If the selected data contain headers then click [ ] My data has headers otherwise no need. You can choose the way you want your data to be interpreted. Then click OK.

Step 4

Select the other stack of data by clicking the marked tab for Selection 2.

Step 5

Change worksheet to select data for Selection 2 to Source 2 by clicking the Change sheet tab. Then click OK.

Step 6

Now select the data manually and for the case here click [ ] My data has headers. And then click OK.

Step 7

Now to add the data from third source, we need to increase the selection range by clicking on the marked + sign.

Step 8

Select the other stack of data by clicking the marked tab for Selection 3.

Step 9

Change worksheet to select data for Selection 3 to Source 3 by clicking the Change sheet tab. Then click OK.

Step 10

Now select the data manually and for the case here click [ ] My data has headers. And then click OK.

Step 11

Select the Vertical tab.

Step 12

Select a blank range for the final result display. You can either show the result in any of the existing worksheets (and select any blank range) or choose a new worksheet. In this illustration, we have chosen New worksheet.

Final Result Display

Now we have the complete data in new worksheet [Sheet4].

Final Stacked Data

Final stacked data in new worksheet.

Stack Rows - Horizontal

In horizontal stacking, the data is stacked side-by-side, therefore, the user need to make sure that the data in all the stacks is formatted row-wise, so that after stacking the final table will contain sensible data.

Here, we have sample data from two different sources. We will use the horizontal stack rows to create a combined table.

Step 1

Click on the Stack Rows command under SheetKraft tab.

Step 2

A window will appear, then select the data manually for Selection 1 by clicking the marked tab in screenshot below.


Step 3

If the selected data contain headers then click [ ] My data has headers otherwise no need. You can choose the way you want your data to be interpreted. Then click OK.

Step 4

Select the other stack of data by clicking the marked tab for Selection 2.

Step 5

Now select the data manually and for the case here click [ ] My data has headers. You can choose the way you want your data to be interpreted. Then click OK.

Step 6

Select the Horizontal tab.

Step 7

In this illustration, we have chosen the existing worksheet [Sheet2!$H$2:$I$17] for final result display.

Final Result Display

Now we have the complete data in the selected range in the same worksheet.

Final Data

Final stacked data combined in horizontal direction.