I am having issues with duplicating lines of info i am currently using a
SUMPRODUCT and and INDEX function but can n ot seem to get it to work
acurately.

Current Data
EQ# Cost Code Hours
1 2.2.200
1 3.2.710 4
1 3.4.700 3
1 3.4.710 5
1 3.4.710 6
1 3.4.710 5
1 3.4.710 2
1 3.4.710 2
1 3.4.710 2
1 3.4.710 8
1 3.4.710 7
1 3.4.710 8
1 3.4.710 7
1 3.4.710 6
1 3.4.710 4
1 3.4.710 6
1 5.2.100 5

I would like to go to a second sheet put in 1 eq number and have it populate
the cost codes and sum of hours within those cost codes without duplicating
cost codes and hours.