Append 2nd row Name value in 1st row Content column
Pls. help me to solve the belowI have the temp table as below:
S.No Name ID Content
1 test1 123 Successfully received test1 mail
2 test2 123 Successfully received test2 mail
3 test3 789 Successfully received test3 mail
Since the 1st and 2nd row has same ID value, i need to append the 2nd row name in 1st row's content column. i.e., output should be as below
S.No Name ID Content
1 test1 123 Successfully received test1, test2 mail
2 test2 123 Successfully received test2 mail ---------This should be deleted
3 test3 789 Successfully received test3 mail