Forum Discussion
Solved
Group By column to unpivot
Hi all! I have a table like such: ID Item Color a123 001 red a123 002 blue b456 001 blue c789 001 red c789 002 blue c789 003 purple and I need it to be ...
I wonder whether a transformation of this type (second query in the file) is no longer useful.
But this can only be known by you depending on what you have to do next.
This solution can be simplified (see query ----2a)
I wonder whether a transformation of this type (second query in the file) is no longer useful.
But this can only be known by you depending on what you have to do next.
This solution can be simplified (see query ----2a)