How to delete duplicate data among multiple columns in Excel?

[elephant]

The table represents keywords of each item. keywords have duplicate entries of each item, and one keyword is placed in one cell, different item can have different number of keywords. how should i delete the duplicates of each item in excel.
for example:
item keywords
A -> 123 234 456 123 234
B -> 23 456 23 567
and after deleting duplicate keywords, it should be:
item keywords
A -> 123 456 234
B -> 23 456 567

 

[JB_Scotland]

Try using an advanced filter from the "Data" menu and selecting the "Unique records only" checkbox. You can filter in place or copy to a new place.

 

[elephant]

Try using an advanced filter from the "Data" menu and selecting the "Unique records only" checkbox. You can filter in place or copy to a new place.

But advanced filter works with multiple rows. but i want to delete the particular cells.

 

[JB_Scotland]

You could row by row, copy, paste special transpose, filter unique records only, copy, paste special transpose. That would get your unique keywords by row.

I tried VBA to do this but was running into problems. It worked for me manually though it may be too long winded if you have a vast amount of data.