I have an issue which I suspect may be fairly easy to solve but I can't seem to find any previous questions about it.

Customer Type Product
Peter Proactive Car
Sven Reactive Wheels
Sven Proactive Wheels
Peter Proactive Wheels

What I would like is that when a customer appears twice, and when the type is the same. Like with "Peter", then the products would add together. The ideal result would look like: (notice that Sven's products does not combine because the type is different).

Customer Type Product
Peter Proactive Car
Sven Reactive Wheels
Sven Proactive Wheels
Peter Proactive Wheels & Car

Ideally I would like to do this without using VBA, does anyone have any solution for this?

Thank you so much in advance.