Create new rows based on conditions

[anhdo92]

Hi,

I have a dataset that looks like below

What I wanna do is to generate new rows based on certain conditions such as:

If Company Entity is MBB then generate 2 more rows with ProcessingOrg PM-MBB-A11SG  AND PM-MBB-A11UK 

If Company Entity is MIMI then generate 1 more row with Processing Org PM-MIMI-HQ8SG

If Company Entity is MBP then leave Processing Org as it is

Output should look like this

Any help is appreciated!

Thanks

[DavidP · Accepted solution]

This is how I would do it

[Hugo · Accepted solution]

DavidP's solution is elegant and probably faster than my approach.

The approach I would have taken would be to create a text file with the CompanyEntity and the required suffixes, then to perform a join on CompanyEntity, with a formula tool afterwards to modify the ProcessingOrg

[anhdo92]

Perfect! Thanks guys!