How to update the values in columns - Need Help

[alt_tush]

Hi,

We have following set of data where from Field2 till Field6 have "0" & "1" Numeric values. (Int64). We have fixed number of columns in below table. Name column have unique name values.

Input Data ;

Name	Field2	Field3	Field4	Field5	Field6
Jack	1	1	0	0	1
Mike	0	1	0	0	1

I am expecting below output every row have only one "1" value in column and rest of the column value should become "0".

For next row if same column have value "1" then it should update "0" and other column value should be "1".

The logic is there should be only one time value "1" in each row. If there are multiple "1" then others "1" value should replace with "0".

This logic i need based on group level of Name column.

For example in above table in "Jack" row there are total 3 "1" values found in columns. So workflow should create the 3 records of Jack entries. For example :-

Name	Field2	Field3	Field4	Field5	Field6
Jack	1	0	0	0	0
Jack	0	1	0	0	0
Jack	0	0	0	0	1

Expected Output : -

Name	Field2	Field3	Field4	Field5	Field6
Jack	1	0	0	0	0
Jack	0	1	0	0	0
Jack	0	0	0	0	1
Mike	0	1	0	0	1
Mike	0	1	0	0	1

Can you please assist me.

[Qiu · Accepted solution]

@alt_tush 
We can use the Multi-row tool to identify the null 0 values.