Update last value into first row

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

Hi @Garyy

Check out this thread. It might help you.

Regards