Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-16-2019, 04:35 AM
ballpoint ballpoint is offline Merge two datasets on the basis of unique identifiers Windows 10 Merge two datasets on the basis of unique identifiers Office 2016
Advanced Beginner
Merge two datasets on the basis of unique identifiers
 
Join Date: Sep 2017
Posts: 42
ballpoint is on a distinguished road
Default Merge two datasets on the basis of unique identifiers

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!
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft