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
Thank you.