Change field values based on a condition

[Mario36]

Is there a way to achieve the below ?

The logic is, on any given column if there exists a value '1' then the next columns need to be blank or null.

[atcodedog05]

Hi @Mario36 

Please share the data in an input excel file.

[Mario36]

Hi @atcodedog05 

Here you go

[atcodedog05 · Accepted solution]

Hi @Mario36 

Here is how you can do it.

Workflow:

Hope this helps : )

[Mario36]

@atcodedog05  Awesome. This helps. Thanks much

[atcodedog05]

Happy to help : ) @Mario36 

Cheers and have a nice day!