This is how the data is in the sql server database table:
Sql data table
ID cases value A value B
1 10 a d
2 10 b e
3 10 c f
4 20 1 4
5 20 2 5
6 20 3 6
7 30 I 1V
8 30 II V
9 30 III V1
I need a query which return the result like this:
| 10 | 20 | 30 |
|______ ||__ |
| a | d | 1 | 4 | I | 1V |
| b | e | 2 | 5 | II | V |
| c | f | 3 | 6 | III | V1 |
|___|___|__||___ ||