How to eliminate zeros in a row

Hi there-

I created a formulation and it does the calculation and assign numbers to column A, B, C, D, E, F, G, H, I, J.


----A---B---C---D---E---F---G---H---I---J
R1--1---0---0---0---0---0---0---0---0---0
R2--0---3---0---0---0---0---0---0---0---0
R3--0---0---0---0---4---0---0---0---0---0
R4--0---0---0---0---0---0---0---1---0---0
R5--0---0---0---0---0---0---0---0---0---6

This is how table looks like. Every row only has 1 number and the rest is always 0. I am trying to create a formulation to capture the only value in the row. So I will have another Column which will be called FINAL COLUMN, This Column will display the only value in the row. So for R1, it will be 1 or for R5, it will be 6. I cannot use sum because the number has spaces in front of them and I really need these spaces for my database formulation. So is there any way to capture this number with it's spaces. So there will be no change for the value.