Hello!
I'm working with a big amount of data so this is about how to do something automatically. Let me explain what's the problem: I just did the combination of almost 2000 different cells (so following the formula C=n!/(n-k)!...with k=4), but now I'd like to do also the combination of each single row I obtained.
Example
1) sentence1 sentence2 sentence3 sentence4
2) sentence1 sentence2 sentence4 sentence3
3) sentence1 sentence3 sentence2 sentence4
4) sentence1 sentence3 sentence4 sentence2
5) sentence1 sentence4 sentence2 sentence3
6) sentence1 sentence4 sentence3 sentence2
....
So here I have the initial part of my combinations, and I'd like to insert after each row its own combinations (this second one, actually it's not a combination, it's a simple repetition of some of those elements that I need to do):
(A) (B) (C) (D)
1) sentence1 sentence2 sentence3 sentence4
• A C B D
• A D B C
2) sentence1 sentence2 sentence4 sentence3
• A C B D
• A D B C
3) sentence1 sentence3 sentence2 sentence4
• A C B D
• A D B C
4) sentence1 sentence3 sentence4 sentence2
• A C B D
• A D B C
5) sentence1 sentence4 sentence2 sentence3
• A C B D
• A D B C
6) sentence1 sentence4 sentence3 sentence2
• A C B D
• A D B C
....
Maybe I've not been so clear, but, considering one row at a time, I'd like to insert 2 more rows with the same elements, but in that particular order...of course, when you switch to another of the initial rows (for example from "1)" to "2)"...) the elements (sentence1, sentence2, sentence3...) change, so they would be different.
Here is also another example about that order I'm trying to obtain.
http://s18.postimg.org/richsxpmx/Col...bination_1.png
Thank you in advance!
Bookmarks