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