I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible.
Here is the example:
Id Owner Name
A1 Owner 1
A1 Owner 2
B1 Owner 3
B1 Owner 4
C1 Owner 5
C1 Owner 6
D1 Owner 7
D1 Owner 8
Here we have one unique id (eg: A1) associated with two Owners (Owner 1 and 2), I need this to be pulled in another sheet in the following format
Id 1st Owner Name 2nd Owner Name
A1
B1
C1
D1