Hi there,
I would like to assemble my data in a comparison matrix from a list of pairs. I feel I can do it with MATCH and VLOOKUP, but I am struggling a little bit.
My data is like this:
A B C
1 Label 1 Label 2 5
2 Label 1 Label 1 2
3 Label 3 Label 1 6
4 Label 2 Label 2 4
5 Label 2 Label 3 3
And I would like to get something like this:
Label 1 Label 2 Label 3
Label 1 2
Label 2 5 4
Label 3 6 3
I don't particularly want to have a complete matrix at the end, but just correct values at the right intersections. I am struggling a bit because on a similarity matrix like this, the data is duplicated, but this is also the case with my list, in which I am not controlling whether I have "Label 1 x Label 2" or "Label 2 x Label 1". I don't care where to place the value on the matrix, but it's kind of confusing me.
Thanks a lot for your help and your advice, let me know if I can clarify more!
G.
Bookmarks