I have two columns. The letter in one column needs to replace number(s) in the other column.
A 2.003
A 2.003
B 6.007
B 6.007
C 10.011
C 10.013
D 15.016
D 15.016
D 15.016
D 15.021
D 15.022
E 24.025
F 27.028
G 31.032
H 35.036
H 35.038
I 39.041
I 39.042
J 44.045
A 2.003
A 2.003
A 2.003
B 7.008
The A needs to replace the 2, the B needs to replace the 6, the C needs to replace the 10, etc.
The catch is that it isn't always the same letter/number combination. Looking at the end of the sample, the B needs to replace the 7 in the next set.
Is there a formula I can apply to make this substitution?
Thank you!
A 2.003
A 2.003
B 6.007
B 6.007
C 10.011
C 10.013
D 15.016
D 15.016
D 15.016
D 15.021
D 15.022
E 24.025
F 27.028
G 31.032
H 35.036
H 35.038
I 39.041
I 39.042
J 44.045
A 2.003
A 2.003
A 2.003
B 7.008
The A needs to replace the 2, the B needs to replace the 6, the C needs to replace the 10, etc.
The catch is that it isn't always the same letter/number combination. Looking at the end of the sample, the B needs to replace the 7 in the next set.
Is there a formula I can apply to make this substitution?
Thank you!