Pivot Columns

Description

Widens the data with the help of value, index, and labels columns.

Input

Data only

Output

Transformed Data

---

Configuration Fields

Index column

• Generate a new row for each change of value in the index column.

Labels column

• Create a column for each value in the label column.

Values column

Populate cells with the values of the values column. When several rows have the same index and label, the pivot only keeps the value corresponding to the last row in the output.

Sample Input

id	category	product	price	in_stock
1	Electronics	Laptop	500	true
2	Electronics	Camera	350	false
3	Electronics	Tablet	250	true
4	Furniture	Sofa	600	true
5	Furniture	Bed	450	true
6	Furniture	Table	150	false

---

Sample Configuration

---

Sample Output

category	Laptop	Camera	Tablet	Sofa	Bed	Table
Electronics	500	350	250
Furniture				600	450	150

---