Combining two worksheets with same case identifiers

  • Thread starter Thread starter matthewdwood82
  • Start date Start date
M

matthewdwood82

Hello,

I am trying to merge two workbooks containing data from an
experiment. The first three columns have identical data in both
workbooks, and include a participant number, value for Variable1,and
value for Variable2. Each participant takes up about 12 rows of the
worksheet, this includes all possible combinations of Variable1 and
Variable2. The last three columns represent judge ratings. Half of
these ratings are entered in Worksheet I, and half of them in
Worksheet II. Some rows in Worksheet I contain missing data which is
contained in Worksheet II. How do I go about combining these data?
-Matt


An example of worksheets:

WS I

Participant___Var1___Var2___Judge1___Judge2___Judge3
1001 a a 1 1
1001 a b 1 1
1001 a c 1 1
1001 a d 1 1
1001 b a 1 1
1001 b b 1 1
1001 b c 1 1
1001 b d 1 1
1001 c a 1 1
1001 c b 1 1
1001 c c 1 1
1001 c d 1 1



WS II


Participant___Var1___Var2___Judge1___Judge2___Judge3
1001 a a 1
1001 a b 1
1001 a c 1
1001 a d 1
1001 b a 1
1001 b b 1
1001 b c 1
1001 b d 1
1001 c a 1
1001 c b 1
1001 c c 1
1001 c d 1
 
One way,
Add 3 new columns to ws1
with a formula =if(d2="",ws2!d2,d2) for judge1
and for judge 2 =if(e2="",ws2!e2,e2)
and for judge 3 =if(f2="",ws2!f2,f2)

extend them down
check that they line up and make sense
then do an edit copy and edit paste special, values ...........to change the
formula's
back to values.
good luck
 
Due to its graphics effects, Windows Vista is very heavy on your system and

causes slow speed even after upgrading the hardware. Here are a few tricks and
tips to enhance performance of Windows Vista.

Disable useless start up items

Some applications like Windows Sidebar, Windows media player, Nero check
Realplayer message centre and other applications loaded at the start up of
Windows Vista are useless and consumes a lot of RAM and CPU usage.

Disable services which you don't require:

Go to Start » Run and type Services.msc at command prompt.

There are several services you can disable to help improve performance.

Disable UAC (User Account Control)


Disable Network Printer Search:

Explorer can slow down when browsing through shared folders and network computers on local network for printers. This sounds like a great feature and may be useful but you can get maximum performance by disabling it.
 
Back
Top