Condition
1 Last row value update in first row which column start with “X-”
2 Only update which has Duplicate ID and State column row value
3 Get last value which is not empty
Input:
Output:
Yellow highlited is updated value and blue is which vlaue want to update
@Anil_G