I am getting repeated values on each row of the column. Below is the table. There are only 2 distinct value for Code status but it creates duplicate in column code. Also, for Primary code there is only one distinct code but it gets repeated on each row. Any idea to resolve this issue. Thank you
| ID | Code | Code_Status | Primary Code |
| 4 | P07.03 | CPR-Full Code | STEMI |
| 4 | P07.03 | No CPR | STEMI |
| 4 | C67.9 | CPR-Full Code | STEMI |
| 4 | C67.9 | No CPR | STEMI |
| 4 | C68.9 | CPR-Full Code | STEMI |
| 4 | C68.9 | No CPR | STEMI |
| 4 | D50.9 | CPR-Full Code | STEMI |
| 4 | D50.9 | No CPR | STEMI |
| 4 | E21.3 | CPR-Full Code | STEMI |
| 4 | E21.3 | No CPR | STEMI |
| 5 | E78.5 | CPR-Full Code | VTE |
| 5 | E78.5 | No CPR | VTE |
| 5 | E86.1 | CPR-Full Code | VTE |
| 5 | E86.1 | No CPR | VTE |
| 5 | G89.3 | CPR-Full Code | VTE |
| 5 | G89.3 | No CPR | VTE |
| 5 | J21.9 | CPR-Full Code | VTE |
| 5 | J21.9 | No CPR | VTE |
| 5 | P29.12 | CPR-Full Code | VTE |
| 5 | P29.12 | No CPR | VTE |
