Using Qlikview is possible to transform a table like that:
The represents the student and each A and B a different test... My original database migrate the data in the first format but I needed into the second...
You could find a nice video showing how to do it on this url Power of Qlik Script - Reshaping Data with Crosstable (video)
Hope this help.
Yes its possible. You can use the Crosstable Function.
Retrieving data ...