References And Lookup

[JR573PUTT]

I have a file with several sheets, sheet 1 has the name in column H
color code in column J and units in column N as below:

col H
Vehix
Vehix
Vehix
Conci

col J
97
87
25
97

col N
1800
2400
3600
1800
On sheet 2 I want to reference this data and create a summary of colo
codes, in column A I want to list the Names of all but only list th
name once, in columns b through z, row 2 I want to list the color code
as below:


col A
Vehix
Conci

col b
25

col c
87

col d
97

I will hard key the color codes on sheet 2, I want to create a formul
to list the each name once, and a formula to sum up the color cod
total units for each style.

What is the formula to list the name once?

What is the formula to lookup the color code for the styles?

Thanks

 

[JR573PUTT]

Any expert excell users in lookups and references?

 

[JR573PUTT]

any experts out there in lookups and references?