Hello Everyone
Can some one please help me convert the below Data
| Name | Code | Age | Gender | Rank | Placing |
| CTPT | BT5 | 15 | | | |
| CSH | BBD | 20 | | | |
| DPL | 918 | 115 | M | 1236 | 36 |
| DPL | 918 | 115 | F | 1236 | 36.4 |
| DPL | 918 | 115 | F | 4589 | 36.4 |
| LMP | BW7 | 1113 | M | 21498 | 1.757 |
| LMP | BW7 | 1113 | M | 203476 | 1.757 |
To this
| Name | CTPT | CSH | DPL | LMP |
| Code | BT5 | BBD | 918 | | BW7 | |
| Age | 15 | 20 | 115 | | 1113 | |
| | | | | - | | - |
| Gender if 'M'(Rank & Placing) | - | - | 1236 | 36 | 21498 | 1.757 |
| | | | | | 203476 | 1.757 |
| | | | | | | |
| | | | | | | |
| Gender if 'F'(Rank & Placing) | | | 1236 | 36.4 | | |
| | | | 4589 | 36.4 | | |
