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 · Accepted solution]

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!

[soncoku]

So simple and yet so powerful.
@Emil_Kos Thank you. During these months that I've been asking questions here in the Alteryx community, you've been a great help to me. I just want to say thank you and let you know that I appreciate your help a lot 🙂

[Emil_Kos]

Hi @soncoku,

Thank you for your kind words 🙂 

It is a pleasure to help people across the community.  Especially to those that are appreciating your efforts.