company wise person and work hour

i want to see which person and how many hours work with this company
i attached a worksheet for example, please help me..
thanx in advance with help of formula not VBA..

i think you want a result, which look likes this:
Company Person Name Work Hour
c-1 John 19
c-2 Sandy 10
c-3 Denis 23
c-4 Lucy 34
c-5 Jassi 52
c-6 Kitty 23
c-7 Henry 23
c-8 Prima 43



in column L use the formula "=OFFSET($A$1,0,MATCH(TRUE,OFFSET($A$1,MATCH($K2,$A$2:$A$9,0),1,1,8)<>"",0),1,1)"
in column K use the formula "=OFFSET($A$1,MATCH($K2,$A$2:$A$9,0),MATCH(TRUE,OFFSET($A$1,MATCH($K2,$A$2:$A$9,0),1,1,8)<>"",0),1,1)"

Both are array formulas, so use ctrl+shift+Enter to apply the formula

I don't understand... Don't you see that from the table?

thanx a lot for solve
this is exactly which i want