I Have a table that look like this
Company Date Paper Condition
Company1 19-12-2007 PaperA Release Second Term
Company1 19-12-2007 PaperA Add Third Term
Company1 19-12-2007 PaperA Append First Term
Im trying to replace duplicate with empty which will result in
Company Date Paper Condition
Company1 19-12-2007 PaperA Release Second Term
Add Third Term
Append First Term
So Far all i've tried is using distinct
and it does not work as expected.
Thanks in advance!