Skip to main content

Cross Tab Tool

Use Cross Tab to pivot the orientation of data in a table by moving vertical columns onto a horizontal axis and summarizing data where specified.

The Cross Tab tool is the reverse application of the Transpose Tool, which pivots the orientation of the data from horizontal to vertical. There is no limit to the number of rows or columns that you can pass through Cross Tab.

If 2 or more cells contain the same string with different capitalization, a number is appended to the string name after the first instance. For example, ColumnID and columnId become ColumnID and columnId2.


This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.

Configure the Tool

  1. Select a column from Create New Column From. A new column is created for each unique value.

  2. Select your New Column Names. Select Reset to reset your selected column names.

  3. Select a column from Populate with Values From. The values from this column are used to populate the new columns.

  4. Select one or more Output Method for combining multiple values in a column. Each method selected appears as a new column in your data.

    • Concatenate Values: Separates the values using the separator specified in the Separator field.

    • Use First Value: Displays the first value found.

    • Use Last Value: Displays the last value found.

    • The character specified in the Separator field is automatically added between concatenated strings. This option is only used when concatenating strings.

  5. Select a Character Length. If a string in the data is larger than the specified length, a warning is shown in the Results Grid and the data is truncated.