Dear all,

I have a worksheet

A B C
Days Name Type
5 Kent Computer
0.5 Kent Safety
3 Susan Computer
2 Peter Management
1 Peter Safety

I want to consolidate the data above into the following table

A B C D
Name Computer Safety Management
Kent 5 0.5 0
Susan 3 0 0
Peter 0 1 2

What should the formula use in the table?

Thanks
Turk