

# Unpivot columns into rows transform


Use this transform to convert column names into values of a new column and generate one row for each column in the original row.

**To add an Unpivot Columns Into Rows transform:**

1. Navigate to your visual ETL job in Amazon SageMaker Unified Studio.

1. Choose the plus icon to open the **Add nodes** menu.

1. Under **Transforms**, choose **Unpivot Columns Into Rows**.

1. Select the diagram to add the node to your visual ETL job.

1. Connect the transform node to a data source node.

1. Select the node on the diagram to view details about the transform.

1. Under **Unpivot names column**, enter a column to create out of the source column names.

1. Under **Unpivot values column**, enter a column to create out of the source column values.

1. Under **Columns to unpivot into the new value column**, select the column or columns whose names will become the values of the new column.