What I have in Excel document:
A B
Abc 12:34
Def 56:78
Ghi 90:12
Jkl 34:56
...
What I want to achieve with those values:
C D E F
Abc 12:34 Def 56:78
Abc 12:34 Ghi 90:12
Abc 12:34 Jkl 34:56
Def 56:78 Ghi 90:12
Def 56:78 Jkl 34:56
Ghi 90:12 Jkl 34:56
...
Explanation:
Columns A and B can contain any combination of text and numbers (if that is important at all), this example only displays the most common structure. It should create combinations only for rows "on the way down", i. e. "Abc...Def..." is enough, there shouldn't be "Def...Abc...".
There are many examples around, but I am struggling to find a version of such VBA that works with multiple columns and doesn't repeat combinations.
Here is one example that is simple. But, it's for only one column and it also repeats values:
http://www.mrexcel.com/forum/excel-questions/412952-create-list-all-pair-combinations.html#post2046893
Thank you in advance.