Hi Experts,
Could you please advice me to get alternative 'M' and 'F' Records alphabetically from below table structure.
| id | sex | Fname | Exam |
|---|
| 100 | M | ARUN | ALSARMEDICINE |
| 101 | M | BARATH | GASTROMEDICINE |
| 102 | F | BHAVITHA | HINDCOMEDICINE |
| 103 | M | CANTO | HOMEMEDICINE |
| 104 | | AMANDA | DIABETIC |
| 105 | | DAMITRI | KAPLICMEDICINE |
| 106 | M | EMINTO | MAPLOSCOPIC |
| 107 | | FALKON | PROMETRIC |
| F | CHINTOO | INTERNAL |
| F | DAYAVATI | LANCROSCOPIC |
| 110 | | HUDSON | QUADRAPIC |
Could you please give me an idea to achieve in the below format.
| id | sex | fname | exam |
|---|
| M | | ALSARMEDICINE | | F | | DIABETIC | | M | | GASTROMEDICINE | | F | | HINDCOMEDICINE | | M | | HOMEMEDICINE | | F | | INTERNAL | | M | | KAPLICMEDICINE | | F | | LANCROSCOPIC | | M | | MAPLOSCOPIC | | M | | PROMETRIC | | M | | QUADRAPIC |
|