I have table like this
ID Status
1 5
1 6
1 7
2 5
2 6
2 7
I need the result like below
ID col1 col2 col3
1 5 6 7
2 5 6 7
Please help me
See Question&Answers more detail:os