Merge two datasets on the basis of unique identifiers

ballpoint · #1 10-16-2019, 04:35 AM

I am trying to merge two datasets, or two sheets really, on the basis of the same unique identifier. The sheets would work around the following principle:

The first one is a list of items. The second is a list of interactions between items.

Thus, the first will be something of this kind:

Code:

Item identifier | Item feature 1 | Item feature 2 | Item feature ...

The second will contain unique interactions (and thus repeated values) and will be:

Code:

Item identifier 1 | Item identifier 2
Item identifier 1 | Item identifier 3
Item identifier 1 | Item identifier 4

What I am trying to accomplish is basically replacing the simple Item identifier cell in sheet 2 with the entire row in sheet 1. So the result should be something looking like this:

Code:

Item identifier (a) | Item feature 1 (a) | Item feature 2 (a) | Item feature ... (a) | Item identifier (b) | Item feature 1 (b) | Item feature 2 (b) | Item feature ... (b)

I did find a couple of useful suggestions here and there but I am not quite sure they would apply to my scenario. I would be most grateful for any suggestion!

Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word mail merge with unique charts	retro	Mail Merge	8	09-11-2019 02:56 PM
Mail Merge List of Items for Unique OwnerIDs	HunterH	Mail Merge	1	10-12-2018 02:03 PM
Unique data per record in mail merge chart	aplarsen	Word VBA	2	02-16-2018 04:01 PM
Activating Unique Links in Email Messages Using a Mail Merge	User02182016	Mail Merge	1	02-23-2016 06:02 PM
Mail Merge URL - a unique question	kitefrantic	Mail Merge	1	12-31-2013 07:34 PM