My table rows are like below
Id marks
Row1: 1 15
Row2: 1 16
Row3: 1 17
Row4: 2 18
Row5: 2 19
Row6: 2 20
and I want to merge all the rows into a single row , can anybody help me please!!!!
output should be like below
Id marks1 marks2 marks3 Id marks1 marks2 marks3
Row1: 1 15 16 17 2 18 19 20