# Pivot rows into columns transform


Use this transform to aggregate the values of a numeric column into categories by using the values of the columns configured.

**To add a Pivot Rows Into Columns 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 **Pivot Rows Into Columns**.

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 **Aggregation column**, select a numeric column to use.

1. Under **Aggregation**, select a Spark function to apply to the aggregation column.

1. Under **Columns to convert**, select columns whose values will become new columns.