Good day to all VBA experts!

I am facing a problem in creating a macro for my own work, which I've tried several ways by using for loop, but end up a bunch of mess.

My problem is, let's say I have multiple distinct members (A,B,C,D,E,F) at column B, where each member has different numbers associated with it on column C.

I would like to have my result shown on the right hand side in below picture, where I wish to make the numbers to be combined to a single cells with a newline chr(10) for each members from column B.

May I know is there any way that I can achieve it?

Appreciate any codes that can make this possible!

Cheers!


VBA.JPG