Remove same/identical values in a row and keep non-identical values

[Kim Vaarts]

I want to remove the same values from a set of different string variables in a row regarding the same person (panel data) e.g. person 1:
Var1 Var2 Var3 Var4
sunsine rain sunshine rain

I want Var1= sunshine and Var2= rain to be kept in the dataset,
"sunshine" and "rain" need to be removed in Var3 and Var4 and need to become empty cells.

Please help asap! Thanks in advance!

[Clyde Schechter]

Duplicate post. See https://www.statalist.org/forums/for...entical-values if interested.