Is there a formula, or series of formulas, that I can use to copy the value from a cell in the same row and add the next non-used digit to it? See image for desired result.
If your original list is in column A, starting at A1, in B1, put this and drag down:
Note that this works specifically for the data you show here.
Please login first before posting an answer.