Removal of duplicates when there is a partial match

[stevecassidy7777]

Hello-

We are working with a list of numbers separated by commas. We are looking to have the lines that contain "part" of what another line contains, removed.

For example:

Before          After

4,5,9          3,4,5,9

3,4,5,9             

5,9

3,5,9

I was unable to find solutions to this so any help would be appreciated.

Thank you,

[Watermark]

Here you go:   Please hit the accept solution and give it a thumbs up if this gets you what you need. 

 

 

[stevecassidy7777]

Thanks for the quick response. It seems I may have over-simplified my data example. It would look more like the below example.

Before          After

4,5,9            3,4,5,9

3,4,5,9         1,2,6

5,9               40,41,42,43

3,5,9

1,2

1,2,6

1,6

40,41,42

40,41,42,43

[Watermark]

Are you needing it in 3 rows?  Not clear on what you're trying to achieve in the 'after' . What is the result goal? You need to know all the individual numbers that are in the 'before'?   It should work the exact same regardless of row count or what's in the row

[mjawahir]

How to combine when data is partially matching.?

Please refer the attached excel for data input:

when item no, text, text1 are same and if the data column having partial matching need to club the price A, price B so 3 lines will come as 1 row with the added price. since item no 9 is having different should leave as it is.

Please guide me or suggest a tool to do this task.