Thank you for this amazing Forum!

Im having some sort of trouble in excel

Here's the situation

I ve got a really long column (3000 entries) with product codes and corresponding quantities.Since each product can be found in different locations there are multiple entries of the same product code.So i need a way to sum up all the quantities in a different sheet next to a list

1st Table

PrdCode Quantity Location

4001 2 5

4001 5 2

4001s 11 15

17403s 3 5

17403s 1 8

4001 2 1

4001s 12 12

Desired Result in different sheet

PrdCode Quantity Locations

4001 9 5,2,1

4001s 23 12,15

17403s 4 5,8

I know the Locations with commas is a bit too much to ask and mabye really complicated.The first part would be awesome as well.Just sums per product code would be great.

Thank you!!!!