Data lookup / transpose for duplicate

[budimu]

Please help!!! i have 2 columns, one with names & the other with location codes, but i noticed that the one with names has duplicate names , since one name can have multiple locations... I am trying to figure out a excel formula that will allow me to have all locations for one person on the same row... i try Vlookup, but it only returns the first number it finds...


i have this :

Serge 25

Serge 36

Serge 45

danny 1

danny 3

danny 75

danny 85

franck 22

franck 78


I need this:

Serge 25 36 45

danny 1 3 75 85

franck 22 78

 

[NARAYANK991]

Hi ,


Can you check this out ?


http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/


Narayan

 

[budimu]

thank you so much Narayan!!!!!!!!!