How can I use multi-field formula tool dynamically?

[hlee36]

Input

Field1	Field2	Field3	Field4	Field5	Right_Field1	Right_Field2	Right_Field3	Right_Field4	Right_Field5
1	1	1	1	1	2	2	2	2	2

Output

Field1	Field2	Field3	Field4	Field5
3	3	3	3	3

Is there a way to use the multi-field formula to add [_CurrentField_] and Right_[_CurrentField_]?

[lbardoe]

You could transpose the columns into rows replace the field name that has Right_ with nothing so that all the fields are then Fieldxxxx sum the data based on the field and then transpose the rows back into columns.