transforming 1D tables to 2D and the other way round

transforming 1D tables to 2D and the other way round

Does Dataprep have tools to convert 1D tables to 2D tables and the other way round? The actions that are commonly called "pivot" and "melt".

What I mean is transitioning between these two kinds of table:

2D

id ____ name ____ surname ____ age
00 ____ Matt ____ Jones ____ 30
01 ____ Mary ____ Smith ____ 40

1D

id ____ variable ____ value
00 ____ name ____ Matt
00 ____ surname ____ Jones
00 ____ age ____ 30
01 ____ name ____ Mary
01 ____ surname ____ Smith
01 ____ age ____ 40


Thank you.

    Nederlandse Hulpbronnen