How to combine several rows to one rows?

Jennnnnny

Hello,

My data looks like this:

Records	values
records_0_Name	Jimmy
records_0_Number	1
records_0_Status	Student
records_1_Names	Marie
records_1_Number	2
records_1_Status	Worker

And i want it looks like this:

Name	Number	Status
Jimmy	1	Student
Marie	2	Worker

Any ideas?

Miguel Angel

Hi,

What you aim to achieve here is a Pivot. This operation can be done in a dedicated Pivot, or Prepare recipes. Given we need first to clean the labels records, the latter recipe is the most straightforward option.

The following steps:

will provide the desired output: