There are 5 option columns, which are populated with an x for whichever
option applies. There are only 3 options, two have two columns, and one has
one column.
I am looking for a formula for the three output columns. The formula needs
to look at the 5 columns, determine which column has the x, and then either
populate the output column with a zero, if the x doesn't apply, or with a
number (from another column) if the x does apply.