how to replace the value of a row

[luo]

Hi Guys,

I got a input like

xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total		2	3	4	2	4	7	9
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total	2		8	3	1	3	2		6

And I want a output like 

xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total		1	1	1	1	1	1	1
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total	1		1	1	1	1	1		1

The only way I figured out is to write a formular for each column. Is there an easier way? because I may have dozens of column. Thank you. 

[EW]

If I'm understanding correctly, I think you need the Multi-Field Formula.  

You could use that with an if statement to adjust the Total row only for any number of fields.  

[fmvizcaino · Accepted solution]

Hi @luo ,

You can use a replace function inside a multi-field formula tool to dynamically replace all columns at the same time.

Best,

Fernando Vizcaino