Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Pivot with non unique IDs
I have data that looks like
And I want to get to
I looked at https://forum.vertica.com/discussion/238733/how-do-i-pivot-in-vertica but still stuck. Can anyone help?