Shape · Summarize and reshape

Transpose

Swaps rows and columns, so every column becomes a row. Best for small, wide summary tables.

Also known as: Flip, swap rows and columns

How it works

The Header column is the column whose values become the new column names; blank uses the first column. Its values must be unique, otherwise the run fails rather than silently merging rows. Every other column becomes a row, with its old name in the Attribute column name column (Column by default; pick a name that is not one of the header values). Values of one type keep it; when the columns mix types the transposed cells are text. The output columns depend on the data, so the node first reads the input's column list and then runs the transpose next to the data where it can, falling back to the desktop.

Inputs and outputs

Settings

{
  headerColumn?: string
  labelColumnName: string
}

Example

A KPI summary has one row per metric and you want one column per metric instead. Leave Header column blank so metric supplies the names.

More in Summarize and reshape

• Aggregate — Collapses rows into one row per group and works out values for each: sum, count, average, median, mode, percentiles, longest text and more, cash-flow values such as NPV or IRR, and for a geometry the dissolved shape, extent or centroid. With no group, you get one grand-total row.
• Group Aggregate — Works out a group total and writes it onto every row instead of collapsing them, as the value, a ratio or a percent. For example, each sale as a share of its region's total.
• Running Aggregations — Adds running totals that build up row by row: sum, average, median, min, max, count or standard deviation, optionally restarting per group. For example, year-to-date sales.
• Pivot — Turns the values of one column into new columns, such as one row per store with a column per month. The reverse of Unpivot.
• Unpivot — Turns chosen columns into rows of name and value pairs. For example, Jan, Feb and Mar columns become month and sales rows.
• Split to Rows — Turns a cell holding several delimited values into one row per value. For example, 'red;green;blue' becomes three rows.
• Split to Columns — Breaks one text column into several columns at a delimiter, such as 'London, UK' into city and country.
• Explode — Turns each item of a list column into its own row. For comma-separated text, use Split to Rows instead.