How to duplicate a result of one field based on the value present in another field?

[Jayasuryan]

Hello Everyone,

Am looking for a solution to bring the following output. The 'Cycle time' field is divided using the 'No. of machines' field and based on the value in the 'No. of Machines' column, the answer of the divided value is duplicated with some delimiters (here comma) in the 'Cycle time per machine' column.

Input:

Cycle time	No. of Machines
64.67	1
251.02	4
233.66	4
59.36	1

Output:

Cycle time	No. of Machines	Cycle time per machine
64.67	1	64.67
251.02	4	62.75,62.75,62.75,62.75
233.66	4	58.42,58.42,58.42,58.42
59.36	1	59.36

Please provide your valuable inputs. Thanks in advance.

[Qiu · Accepted solution]

@Jayasuryan 

Hope this is what you need.

[Jayasuryan]

Thanks for the answer @Qiu 

[Qiu]

@Jayasuryan 
Glad to help and thank you for the accept mark. 😁