Can you please help me for the below scenario. I have data in the table like this.
| Employee_ID | COLUMN_A | COLUMN_B | COLUMN_C |
| ABC | | Y | |
| ABC | | | N |
| ABC | Y | | |
| XYZ | N | | |
| XYZ | | | N |
I am looking for the output data like below.
| Employee_ID | COLUMN_A | COLUMN_B | COLUMN_C |
| ABC | Y | Y | N |
| XYZ | N | | N |