Generate predefined number of rows for dynamic n distinct input value

[ngthuyduong93]

Dear Alteryx-enthusiast,

I'd like to ask if there are any ways to generate predefined number of rows (e.g. in this example below: 3) for every unpredefined number of (distinct) input value? 

Hope the picture below clearly describes my goal. 

I've tried to use Generate Rows / Multi-Row / Multi-Field formula and been digging through many alteryx discussions but haven't found any similar case to mine yet.

I also don't wish to use Macro as this case above is just a small part of my total workflow and would increase complexity...

Thank you very much for any recommendation.

[MatthewO · Accepted solution]

Hello @ngthuyduong93 - you can accomplish this using the Generate Rows and Append tools. Attached is an example workflow.

[csmith11]

Slight different solution as well:

[ngthuyduong93]

Wow, thank you all very much for the super fast response 👍 

The solution are also very neat and much simpler than I thought.

Really appreciate all the help from you guys.