VinodKrishnappa
New Member
- Joined
- Aug 6, 2016
- Messages
- 31
Hi Can any one help me on this transpose the available following data in a particular format. This data will continue for more than 650 rows & 26 columns
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
Note: Any Comp with 0 value to be ignored in the transposed data.
Format for transpose
<colgroup><col span="3"></colgroup><tbody>
</tbody>
Please help me on this.
Thanks in advance.
Emp. No. | Name | Comp1 | Comp2 | Comp3 | Comp4 | Comp5 | Comp8 | Comp9 |
2002 | A | 2000 | 800 | 1600 | 2500 | 12500 | 0 | 1500 |
2003 | B | 2200 | 880 | 1600 | 2500 | 12500 | 0 | 1500 |
2004 | C | 2400 | 960 | 1600 | 2500 | 12000 | 200 | 1500 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
Note: Any Comp with 0 value to be ignored in the transposed data.
Format for transpose
Comps | Amt. | Emp. ID |
Comp1 | 2000 | 2002 |
Comp2 | 800 | 2002 |
Comp3 | 1600 | 2002 |
Comp4 | 2500 | 2002 |
Comp5 | 12500 | 2002 |
Comp9 | 1500 | 2002 |
Comp1 | 2200 | 2003 |
Comp2 | 880 | 2003 |
Comp3 | 1600 | 2003 |
Comp4 | 2500 | 2003 |
Comp5 | 12500 | 2003 |
Comp9 | 1500 | 2003 |
Comp1 | 2400 | 2004 |
Comp2 | 960 | 2004 |
Comp3 | 1600 | 2004 |
Comp4 | 2500 | 2004 |
Comp5 | 12000 | 2004 |
Comp8 | 200 | 2004 |
Comp9 | 1500 | 2004 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
Please help me on this.
Thanks in advance.