Remove Duplicates but Dont delete the rows

Hello Excelforum Members

Following code working fine with me, but after removing duplicates, code collapse / combine records.

Value should be keep on same place & should not be move up

For example in column "A" contains data like

VBA
VBA
VBA
ABC
Steave
VBA
ABC
XYV
Steave

After runs of code value has coming
VBA
ABC
Steave
XYV

Please Login or Register  to view this content.

@ JasperD & jindon

Both code are superb & working perfect.
reputation added
Thank you very much