Hi,
Let's imagine I have those raws :
| Name | Value1 | Value2 |
| foo | 1 | 2 |
| foo12 | 1 | 6 |
| foodazd | 5 | 6 |
| fooaoke | 4 | 3 |
| foo56 | 2 | 3 |
| bar | 1 | 2 |
| barjodpez | 7 | 4 |
| barjo | 7 | 4 |
| bar125 | 7 | 5 |
I would like to create a search that gives :
Name | Value1 | Value2 |
foo foo12 foodazd fooaoke foo56 | 1 2 4 5 | 2 3 6 |
bar barjodpez barjo bar125 | 1 7 | 2 4 5 |
So to explain with words, I want to merge raws based on the smallest common substring present in the Name column (here, foo and bar).
Thanks for your help.