Vlookup

Hi, I have a database with information of many part numbers in a column. In other column there is information of the warehouse every part is used, every part number is listed more that one time, depending if it is used in more than one warehouse.

What I need , is a formula that looks in that database and show in a separate sheet every part part number and the warehouses it it used in.

Eg.
Database.

P/n wh
123145 52
123145 30
123145 29
123888 30
123888 29
555555 29
444444 30


desired

p/n wh
123145 30,29,52
123888 30,29
555555 29
444444 30

Thanks.

Try this setup to return multiple warehouses per part number.

very impressive, thanks