Please find the attachment.
I need to merge rows with different columns.
Actual Data
CrId WO Date AppID Status
CR1 wo1 12/1/2020 experian closed
CR1 wo2 12/1/2020 experian closed
CR2 wo3 12/2/2020 Photoshop closed
CR2 wo4 12/2/2020 Photoshop closed
CR2 wo5 12/2/2020 Photoshop closed
CR3 wo6 12/3/2020 MsOffice closed
CR3 wo7 12/3/2020 MsOffice closed
CR3 wo8 12/3/2020 MsOffice closed
CR3 wo9 12/3/2020 MsOffice closed
Desried Result
CrId WO Date AppID Status
CR1 wo1,wo2 12/1/2020 experian closed
CR2 wo3,wo4,wo512/2/2020 Photoshop closed
CR3 wo6,wo7,wo8,wo9 12/3/2020 MsOffice
Please help to how write query to get result as above