Duplicate rows until condition is met

soncoku

Hey everyone. Hope you're doing well.

I have a question and I'd appreciate any help.

I have a column

Name	Month	Cost	Service1	Service2
Soni	5	40	x	x
Jordan	3	40	x	x
Anna	10	40	x	x

Let's take the first row
I want it to duplicate it and add the month by 1 until month = 12

and then continue with the next name etc...

For example

Name	Month	Cost	Service1	Service2
Soni	5	40
Soni	6	40
Soni	7	40
Soni	8	40
Soni	9	40
Soni	10	40
Soni	11	40
Soni	12	40

Emil_Kos

Hi @soncoku,

This was cool.

I rarely have a possibility to use this tool in practice. 

The output itself:

I think it should work for you!

Generate Rows.yxmd