provider id yr
M 908000 0
M 908000 1937
A 1001750 2000
A 1001750 2003
I have a situation where for a single if there are differenr yr's.
1.if the yr is 0, how to change the value of that yr to the other year value the id has.
for M 90800 should take 1937.
similarly for provider A if there are different values take the first value i.e 2000