Hi Every One,
i required the Output which is highlighted in Green
<colgroup><col><col><col><col span="3"><col><col></colgroup><tbody>
</tbody>
i required the Output which is highlighted in Green
Project Name | Week1 | Week2 | Week3 | Week4 | Person Name | ||
P1 | |||||||
P2 | 2 | 5 | S | ||||
P3 | 6 | R | |||||
P4 | |||||||
P5 | 8 | R | |||||
P6 | |||||||
P7 | 5 | R | |||||
P8 | 5 | 10 | R | ||||
P9 | |||||||
P10 | |||||||
P11 | |||||||
P12 | |||||||
Output | |||||||
Person Name | R | ||||||
Week | Week4 | ||||||
Existing Output | |||||||
Project Name | |||||||
1 | P3 | 0 | |||||
2 | P5 | 8 | |||||
3 | P7 | 0 | |||||
4 | P8 | 10 | |||||
5 | #NUM! | #NUM! | |||||
6 | #NUM! | #NUM! | |||||
Required Output | |||||||
1 | P5 | 8 | |||||
2 | P8 | 10 | |||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
<colgroup><col><col><col><col span="3"><col><col></colgroup><tbody>
</tbody>