Hi I have this data set as below.
X Y
- -
1 A
1 A
1 A
1 D
1 J
2 B
2 B
2 D
2 C
2 C
Within a given value of X, when Y=D, I would like to reset the remaining values for Y to D. So the data set should look like this.
X Y
- -
1 A
1 A
1 A
1 D
1 D
2 B
2 B
2 D
2 D
2 D
Any help is greatly appreciated. Thanks!
X Y
- -
1 A
1 A
1 A
1 D
1 J
2 B
2 B
2 D
2 C
2 C
Within a given value of X, when Y=D, I would like to reset the remaining values for Y to D. So the data set should look like this.
X Y
- -
1 A
1 A
1 A
1 D
1 D
2 B
2 B
2 D
2 D
2 D
Any help is greatly appreciated. Thanks!