Copy cells from Sheet 1 to Sheet 2 wherein the returning value is against a specific row

Hi Guys,

i need a help with a formula.

I have a sheet with 9128 lines with product listings. Many of the products are repeated as they come from different buyers. I need to pull up a new list with only unique products with a total quantity required. I did that using the Remove Duplicate from the product listing on the new sheet. I also summed up the quantity needed against each product.

But I don't know how to bring the product name in a next column on sheet 2 so that the product code, product name and total quantity show up together.

Hi,

Attached is the sheet. I need to work on sheet2 wherein I want the desc to come automatically against the article code mentioned on A2 column.

Hi Spencer,

I have uploaded the file on the same thread. Please have a look

Hi,

Please check if the attached is helpful...

Hi,

Great, thank you. I just wanted this only. Great help.

Hi,
I need further help from you on the same file. 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!