Hello Excel Experts,

Need help with the following.

I have a bunch of names with different box numbers. I need to gather all the box number into one cell matching the name. Any help is greatly appreciated.

Example

Original List
Name Box No.
Pete 1
David 2
Jannet 4
David 2
Al 1
Lucy 66
Al 2
Al 3
Lucy 99

Final List
Pete 1
David 2 2
Jannet 4
Al 1 2 3
Lucy 66 99