merging data from 2 files or 2 worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeff - 13 Aug 2007 19:24 GMT

Hello,

I'm trying to merge data in Excel. I have 2 datasets with one common
variable. I've tried several different approaches, and none works. Is
it possible to merge in Excel? Or is the program not that
sophisticated? If I had SAS or SPSS it would be snap.

Thanks.

JK

Reply to this Message

JE McGimpsey - 13 Aug 2007 22:03 GMT

> I'm trying to merge data in Excel. I have 2 datasets with one common
> variable. I've tried several different approaches, and none works. Is
> it possible to merge in Excel? Or is the program not that
> sophisticated? If I had SAS or SPSS it would be snap.

Certainly it's possible to merge datasets. Take a look at the VLOOKUP()
function.

Post back with details if that doesn't help.

Reply to this Message

jpdphd - 13 Aug 2007 22:39 GMT

> Hello,
>
[quoted text clipped - 6 lines]
>
> JK

I don't know of any built-in command that would do this (but, I don't
know everything!).

If every instance of the common variable is in both datasets, you
could simply order the two data sets by the common variable, and then
copy the extra data from one set to the other.

If that is not true, I think you will have to do some serious formula
writing or make a macro...

jpdphd

Reply to this Message

Mac Forum / Applications / Excel / August 2007

merging data from 2 files or 2 worksheets