.png)
Hi, I have a data table which looks something like the below:
Case Name Status
001 ABC Approved
001 DEF Approved
002 DEF Fail
002 EFG Approved
The output that I would like to get is a datatable with distinct Case and Status columns, something like this
Case Status
001 Approved
002 Approved
002 Fail
How do achieve this?