Split Formula with all the Data

[Devika]

Hello,

Request your help in splitting the data as per attached (input and output data)

[atcodedog05]

Hi @Devika ,

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos]

Hi @Devika,

I have created 2 new columns to add Source data in them.

I am not sure how did you calculated: Quantity diff

[grazitti_sapna]

Hi @Devika, give this a try.

Thanks.