Prepare recipe: how to unfold/seperate rows

Tong

I have a table like below. There are some rows, which are combined in one row, because the parameters are the same. For the data cleaning, I want seperate them (like below the second table). How can I do it? Thanks for your help!

Original

Nr	temperature
1	300
2	200
3+4	240
5	200
6	300
7+8+9	500
10	400

wish:

Nr	temperature
1	300
2	200
3	240
4	240
5	200
6	300
7	500
8	500
9	500
10	400

max

Hi @Tong
,

From the prepare recipe, you can use the processor called "Split and Fold", using "+" as the separator. This should transform your data into what you are looking for.

Do not hesitate if you have any further questions.

Max

Tong

@max
thanks! it works!