Fold multiple columns

Perform the opposite of a pivot and fold a list of columns, transforming a wide dataset into a narrow one. This is also sometimes called a melt. This processor outputs two columns: one containing column names and the other containing column values.

Example

student

math

science

arts

Marie

85

83

81

Caroline

74

91

86

Paul

70

85

89

Applying “Fold multiple columns” with class for folded column names and grade for folded values generates the following table:

student

class

grade

Marie

math

85

Marie

science

83

Marie

arts

81

Caroline

math

74

Caroline

science

91

Caroline

arts

86

Paul

math

70

Paul

science

85

Paul

arts

89

Options

Column for folded column names

Column containing the names of folded columns.

Column for folded values

Column containing the values of folded columns.

Remove folded columns

Remove the now empty folded columns.