R
Ray P. Light
I have a series of separate databases of client information, where
each database shares a common client ID number. I need to find a way
to connect these separate spreadsheets by linking them by the common
client ID number.
For example, I have one spreadsheet that has hundreds of cases with
data arrayed as such (note: there may be missing data):
Client ID Var1 Var2 Var3
ABC123 5 4 6
KLM324 3 4
NOP890 2 1 5
And then another spreadsheet that has hundreds of cases with data
arrayed as such (note: may have extra case, and they are in a
different order):
Client ID Var4 Var5 Var6
KLM324 2 2 7
NOP890 4 1 1
ABC123 6 8 3
KRE956 5 3 3
I want to have a way to have Excel merge them so I end up with:
Client ID Var1 Var2 Var3 Var4 Var5 Var6
ABC123 5 4 6 6 8 3
KLM324 3 4 2 2 7
NOP890 2 1 5 4 1 1
KRE956 5 3 3
Help!!
each database shares a common client ID number. I need to find a way
to connect these separate spreadsheets by linking them by the common
client ID number.
For example, I have one spreadsheet that has hundreds of cases with
data arrayed as such (note: there may be missing data):
Client ID Var1 Var2 Var3
ABC123 5 4 6
KLM324 3 4
NOP890 2 1 5
And then another spreadsheet that has hundreds of cases with data
arrayed as such (note: may have extra case, and they are in a
different order):
Client ID Var4 Var5 Var6
KLM324 2 2 7
NOP890 4 1 1
ABC123 6 8 3
KRE956 5 3 3
I want to have a way to have Excel merge them so I end up with:
Client ID Var1 Var2 Var3 Var4 Var5 Var6
ABC123 5 4 6 6 8 3
KLM324 3 4 2 2 7
NOP890 2 1 5 4 1 1
KRE956 5 3 3
Help!!