Hi, Could anyone assist me. Is it possible to merge multiple rows into one with line breaks.
in this cases i need to combine remarks column with using batch name and userid as unique value.
Current cases
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Expected Results
<colgroup><col><col><col></colgroup><tbody>
</tbody>
in this cases i need to combine remarks column with using batch name and userid as unique value.
Current cases
BatchName | UserID | Remarks |
Batch1 | 200123 | MK, 1-Aug-2019,users pending |
Batch1 | 200123 | Jason,1-Aug-2019,users engage |
Batch2 | 200526 | Maria, 1-Aug-2019, attain users details |
Batch3 | 200564 | MK, 1-Aug-2019,explain details to user |
Batch4 | 200118 | Maria, 1-Aug-2019, users engage |
Batch4 | 200118 | MK, 1-Aug-2019, users not answer |
Batch4 | 200267 | MK, 1-Aug-2019, user ask for follow up |
Batch4 | 200267 | Jason,1-Aug-2019,users engage |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Expected Results
BatchName | UserID | Remarks |
Batch1 | 200123 | MK, 1-Aug-2019,users pending Jason,1-Aug-2019,users engage |
Batch2 | 200526 | Maria, 1-Aug-2019, attain users details |
Batch3 | 200564 | MK, 1-Aug-2019,explain details to user |
Batch4 | 200118 | Maria, 1-Aug-2019, users engage MK, 1-Aug-2019, users not answer |
Batch4 | 200267 | MK, 1-Aug-2019, user ask for follow up Jason,1-Aug-2019,users engage |
<colgroup><col><col><col></colgroup><tbody>
</tbody>