I have a table with rows like thisA 1A 1B 3B 3C 44C 44and so on.
and I want it to beA 1B 3C 44
so how can I remove the all the duplicate lines but one?