When designing or personalizing reports, I use Report Designer. I cannot transform the layout of the data visible in the rows - SELECT ABCDE001.VALUE1, ABCDE001.VALUE2 FROM ABCDE001
VALUE1 VALUE2
10 100
55 550
24 240
On the arrangement of data in columns (pivot)
VALUE1 10 55 24
VALUE2 100 550 240
How to make such a transformation?
