I have the following data
Base End RMSA Item 1 RMSA Item 2 RMSA Item 3 RMSB Item 1 RMSB Item 2 RMSC Item 4
I want to convert it to the following format
Key Products RMSA;RMSB Item 1, Item 2 RMSA Item 3 RMSC Item 4
Basically, those with similar results should be grouped into 1 line. However, I can't seem to get it to work using listagg, etc since I'm grouping on two columns.
Is there any way to do this with a direct Oracle query?
#sql #oracle