Need help-
HAVING DATA like this-
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>
need below output as year wise month wise total excluding #N/A
<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>
</tbody>
HAVING DATA like this-
A-Name | B-Year | C-Month |
name | 2011 | 1 |
name | 2012 | 2 |
#N/A | 2010 | 3 |
#N/A | 2015 | 4 |
name | 2012 | 5 |
name | 2013 | 1 |
#N/A | 2014 | 2 |
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>
need below output as year wise month wise total excluding #N/A
Month | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 |
1 | ||||||
2 | ||||||
3 | ||||||
4 | ||||||
5 | ||||||
6 | ||||||
7 | ||||||
8 | ||||||
9 | ||||||
10 | ||||||
11 | ||||||
12 |
<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>
</tbody>