This is a somewhat tricky one to descibre, but I am banging my head against the wall about it - maybe someone here can help.
Problem: My data is a continuous log-file from a psych. experiment with two parts. In the first part, var1 (numerical) is matched with var2 (string). In the third part, Var3 (string) is filled in. The file looks something like this:
What I need is have Var1 filled in also for the second part, so that I'd obtain:
I.e., Var1 needs to be filled in also within the second part of the file (now empty), with the same values it had for the first part, listed in Var2.
I feel my data would have to be reorganised in some way, but I am unsure how. Any help would be highly appreciated!