Hi everyone,
My Data in Column A has linked pairs (e.g [C-D]). The amount of pairs per row varies between 1 and 10 pairs:
In [A1]: [A-B, C-D, A-E], data which I want to simplify into : -> [A-B-E, C-D]
In [A2]: [C-D, G-A, G-B, F-E] -> [C-D, G-A,B, F-E]
In [A3]: [A-B, B-F, E-F, H-I] -> [A-B-F-E, H-I]
In [A4]: [F-G, H-G] -> [F-G-H]
In [A5]: ...
Can I bundle those pairs, and show groups of relations instead (e.g [A-B, B-F, E-F, H-I] -> [A-B-F-E, H-I])
Can anyone inform me how I can tackle this?
See excel-attachment for a similar, more detailed example..
Thank you in advance,
With friendly greetings,
N.
Bookmarks