filter only one cell from various similar cells in a column

hi
i have this following data on the excel to process:


A B C D E

1 123456 .070 3 $50 $150
2 123456 .075 1 $50 $50
3 123456 .090 4 $50 $200
4 987654 .070 1 $20 $20
5 987654 .080 2 $20 $40


where column A is: the product code of the items
B is: the sizes of the product type as per column A
C is: the unit sold for product A size B
D is: price each
E is: total $ sold

considering the data is pretty big i would like to make a summary page that looks as follows:

A B C D E F G H I J
1 PROD .070 .075 .080 .085 .090 .095 .100 .105 .110
2 123456 3 1 0 0 4 0 0 0 0
3 987654 1 0 2 0 0 0 0 0 0

i believe the tallies can be done using the SUMIFS formula... however i am at lost at getting the data from COLUMN A filtered so that it shows only one rather than many...

how do i solve this issue?

thanks in advance!

Marvin

Hi thanks for the SUMIFS formula it really helps

what about the sorting part?

so for a column of:

123456
123456
123456
123456
999999
999999
999999
999999
987654
987654
987654

i'd like to show only 1 row for each product code i.e.:

123456
999999
987654

(eliminating all the duplicates)

thanks alot