Need help with a workflow

[JL-ALTERYX]

Hello,

I am trying to figure out how to remove duplicate values on only certain groupings while keeping every other data the same

I tried using sort into muti row formula and IF functions but have run into issues.

Any other solutions?

I included an Excel file with current and goal WS's

[gautiergodard]

I would recommend solving this using a multi row formula. Attached is a sample workflow that gets you to your goal. You maybe need to adjust based on how your data is grouped and ordered.

***If this provides a solution to your problem, please like this post and mark the issue as resolved!***

[JL-ALTERYX]

I see that worked but what about in cases where there is more data and it wont follow the -2 portion?

I attached an updated file

[binuacs · Accepted solution]

@JL-ALTERYX One way of doing this