I need to convert one table data as follows
| NO | Name | Position | Group |
|---|---|---|---|
| 1 | John | TM | A |
| 2 | MArk | SA | A |
| 3 | Peter | DV | B |
| 4 | Angel | DV | A |
| 5 | Bibin | SA | B |
| 6 | Jerry | TM | B |
| 8 | John | TM | A |
| 9 | MArk | SA | A |
| 10 | Peter | DV | B |
| 11 | Angel | DV | A |
| 12 | Bibin | SA | B |
| 13 | Jerry | TM | B |
above table to get the following result
| NO | TM | TM | SA | SA | DV | Dv |
|---|---|---|---|---|---|---|
| NO | A | B | A | B | A | B |
| — | — | — | — | —- | — | —– |
| John | Jerry | Mark | Bibib | Peter | Angel | |
| John | Jerry | Mark | Bibib | Peter | Angel |
Under Each position need to distribute the name with group wise