4.4.2 Stacking Worksheets to a Single Sheet

Use Worksheet: Stack Worksheets (X-Function = wstacksheets) to stack columns in two or more worksheets in a single workbook, by specified column label(s). Optionally:

  • Filter rows by LabTalk expression (e.g. col(A) > 850 AND col(A) < 1000).
  • Include a dataset identifier (e.g. Sheet Name) to label each row of output.

Dialog Control

Recalculate

Specify the Recalculate Mode.

  • None
  • Auto
  • Manual
Input Workbook By default, the active workbook is selected. Alternately, use the Interactive Range Selection Control to select another workbook.
Matching Label Row Specify a shared label to stack columns (e.g. Long Name)
Common Labels Enter a space-separated list of column(s) to be stacked. Note that if any of the label row data contain spaces, enclose data with parentheses.
Row Filter (optional) Filter output by LabTalk expression (e.g. abs(col(A) > 1)) (hint: use "col(A), not "A" when referring to worksheet columns).
Dataset Identifier Specify a dataset identifier to mark source of output rows:
  • None
  • Range
  • Sheet Name
  • Index
Insert Identifier Before Data Check the box to insert the specified Dataset Identifier before stacked data. Otherwise the identifier column will output to the last column of the Output Worksheet.

By default, it is unchecked. If Append to End of Each Column is checked, this control will be disable.

Output Worksheet Specifies where to output the combined worksheet.
English | Deutsch | 日本語