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!