Enter multiple lines with chr(10) based on cells

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

Hi Allmaths,
try this

Please Login or Register  to view this content.

Originally Posted by YasserKhalil

Try this code

Please Login or Register  to view this content.

Originally Posted by nilem

Hi Allmaths,
try this

Please Login or Register  to view this content.

Thanks to both YasserKhalil and nilem!

Both of the codes work like a charm!

I am still weak at array, so might need to read more to understand the codes.

Once again, thanks! Really appreciate it!

What mean

Please Login or Register  to view this content.

How if i am change to is similar

Please Login or Register  to view this content.

Thank nilem