Below is the sample data of what I have.
I want to summarize at ID level and the result should look something like this.
Can someone please help me with this query. I have looked at concatenate but its not helping. Thanks a lot