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.
Bookmarks