Merging data in one cell from one sheet to another sheet

Hi,

I wish everyone a happy new year!

I have a file which has article code, serial number, description of item and quantity mentioned. There are multiple "s.no." against each article code. When I create the cummulative quantity list using the article codes, I cannot pull out the serial numbers. Since these serial numbers are crucial information, I want them to come in next columen as "456, 5673, 4567" etc. For example,

Art. Code s.no. description qty
1010170_3 2439 Cotton Twine Red TT29 1
1010170_3 2587 Cotton Twine Red TT29 1

I want this information to come in the cumulative sheet as:

Art. Code description qty S.No.
1010170_3 Cotton Twine Red TT29 1 2439, 2587

is there a possiblity to do this?

Thanks in advance!

any inputs?

Hi thanks for the sheet. But I don't need a sum of the s.no. I need them to appear as 2439, 2587. Is there a way to do that?