Check repetition of text in a single cell in excel & delete them to avoid repetition

[arjun0014]

I have thousands of rows like that -
These are the keywords
[TABLE="width: 604"]
<tbody>[TR]
[TD="width: 604"]A1 NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY BASKETBALL
[TABLE="width: 604"]
<tbody>[TR]
[TD="width: 604"]A2 New IXO Collated Screw Gun (Cordless) home use screw gun cordless for everyone[TABLE="width: 604"]
<tbody>[TR]
[TD="width: 604"]A3 Set of 3 stainless steel soup pasta salad bowl chicken soup bowl cookware[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

There is a repetition like in A1 - Basketball , in A2 Gun & in A3 soup bowl . I want excel to find these duplicates text , place them in next corresponding column say in B1 B2 B3 etc. And in third column it would remove these duplicates and place text in C1 C2 C3 . Below are the samples

[TABLE="width: 500"]
<tbody>[TR]
[TD]NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY BASKETBALL[/TD]
[TD]Basketball[/TD]
[TD]NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY[/TD]
[/TR]
[TR]
[TD]New IXO Collated Screw Gun (Cordless) home use screw gun cordless for everyone[/TD]
[TD]Gun , screw[/TD]
[TD]New IXO Collated Screw Gun (Cordless) home use cordless for everyone[/TD]
[/TR]
[TR]
[TD]Set of 3 stainless steel soup pasta salad bowl chicken soup bowl cookware[/TD]
[TD]Soup bowl[/TD]
[TD]Set of 3 stainless steel soup pasta salad bowl chicken cookware[/TD]
[/TR]
</tbody>[/TABLE]


Hope this information helps.
Waiting for early response in this concern.

 

[MickG]

You're welcome