Unpivot Columns

Nodo Transform
TransformData Table→ Data Table

Turn selected columns into Attribute/Value row pairs — like Power Query's Unpivot Columns.

Descripción

Converts wide data to long/tidy data. Select the columns you want to unpivot; every other column is treated as an identifier and repeats across the new rows it produces. Each selected column becomes one output row per original row, with an Attribute column holding the original column name and a Value column holding its value.

Ideal para

  • Turning several period columns (Jan, Feb, Mar, ...) into one Month/Value pair for time-series analysis
  • Reshaping a wide export into the long format most charting and pivot tools expect
  • Preparing data for Pivot Columns downstream, or for a Group By step

Cómo usar

1Connect your table
Pass a wide table into Unpivot Columns' input.
2Select the columns to unpivot
Choose the columns to convert — everything else stays as an identifier column.

Consejos y notas

Select what to convert, not what to keep
You choose the columns being unpivoted — everything else is automatically kept as an identifier, matching Power Query's own Unpivot Columns command.
Ver tutoriales en vídeoVer lista de reproducción en YouTube