BrucevB
New Member
Hi, I have a muti dimensional data set with two variables that I wish to merge into a single worksheet. If you look at the the attached example the data is in the format 'dhid-from-to-var1 or var2' depending upon the worksheet (Table1 or Table2). 'var1' and'var2' represent 2 different ways of measuring the same attribute, but were not collected everywhere in the case of 'var1' so I want to fill in the missing values (missing = -8) var1 values with the corresponding value from 'var2' in Table2. In the original data the variable 'dhid' does change, so 'from' and 'to' values will repeat as the 'dhid' changes.
For each 'dhid' the 'from' and 'to' values may differ for a few values between the two measurements, that data does not interest me. Where the 'dhid' 'from' and 'to' values match I want to copy the var2 value across from Table2 to Table1.
Hope I have explained this clearly and thanks for your time if you reply.
For each 'dhid' the 'from' and 'to' values may differ for a few values between the two measurements, that data does not interest me. Where the 'dhid' 'from' and 'to' values match I want to copy the var2 value across from Table2 to Table1.
Hope I have explained this clearly and thanks for your time if you reply.