I am trying to extract a value from an excel file but can't find a complete solution.
When one of more values in a column are for example '1' I would like to use another value in the same raw(s) where the value is set to '1'.
Any suggestion?

I am trying to extract a value from an excel file but can't find a complete solution.
When one of more values in a column are for example '1' I would like to use another value in the same raw(s) where the value is set to '1'.
Any suggestion?
A few questions: