Hi all Merry Christmas everyone!
I have had to revisit this issue. I have a simplified table Color, Amount Red, 123 Green, 234 Blue, 345 Previously, I have been advised of CTEs and CASE before wherein I was able to get the result but for it I had to assume that such and such Colors names existed. But the thing is that the Color value is not under control and is not a fixed list, so one user could have a Light Green, 456 and another user could define the same as Pale Green, 567 I want the colors to become the header in the output and the Amount underneath,something like Red, Green, Blue, Light Green, Pale Green 123, 234, 345, 456, 567 Please advise Thanks and regards Bhavbhuti
