Can anyone help me about how to add multiple values to one key in excel .
value : 1.per
key : perth
The above 3 values should be added to only one key value and if i get Pbo then, the key value should get perth and another two values also. Can anyone suggest me in excel .