Generating multiple rows based off a value in a column

[tinonsaha]

Hello, I've run into a problem that I'm hoping the community can help me with. I have data that's structured in a way where it there's a field with a list of clients in one column, another field populated by either 'incoming' or 'outgoing' and another field populated with values for the amount of incoming or outgoing. I need to get the data in a way where it shows each client on multiple rows depending on the value of the last field. for example: Client 1 | incoming | 3 needs to look like this Client 1 | incoming Client 1 | incoming Client 1 | incoming Thanks in advance for the help!

[GiuseppeC · Accepted solution]

Hi @tinonsaha,

the Generate Rows tool should do this for you. See below and attached:

Hope this helps!

Giuseppe