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.