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.
Solved! Go to 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