Stack Grids

About Stack Grids

The Stack Grids operation splits a file vertically on selected columns, stacking each slice horizontally.

Example

Use Stack Grids where a file has multiple data grids sharing identical headers arranged horizontally, which need to be combined into a single table.

Use Stack Grids to select the column ‘unnamed (2)’ as a breakpoint.

Now use Remove Rows, Detect Headers and Clip From Column to tidy up the output.

Using Stack Grids

1. Select ‘Stack Grids’ from the Operations menu.
2. Select the columns to use as breakpoints.
3. Add further operations as needed to remove surplus rows and define headers.

Note that grids will be stacked in the order that the pipeline encounters the columns in the input file, not their order in the selector. Choosing columns A, E, and D will produce identical output to selecting columns A, D and E.

See a fully-worked example in the Stack Grids and Fill Down tutorial