Create all possible combinations using 2 columm (Data 1, Data 2)

For example.....take this:

Grouping Data 1 Data 2
1 Male A
1 Male B
1 Male C
1 Female D
1 Female E
1 Female F
1 Female G
1 Female H
1 Female I
2 Male J
2 Male K
2 Male L
2 Male M
2 Female N
2 Female O


and convert it to:

Group Male Female
1 A D
1 A E
1 A F
1 A G
1 A H
1 A I
1 B D
1 B E
1 B F
1 B G
1 B H
1 B I
1 C D
1 C E
1 C F
1 C G
1 C H
1 C I
2 J N
2 J O
2 K N
2 K O
2 L N
2 L O
2 M N
2 M O

Hi
try this macro

it assumes that your input data (group, gender, ID) are in three adjacent columns

select the data to parse (excluding column headings) and run the macro. It should copy your revised list into successive cells begining at cell G2

Please Login or Register  to view this content.

Thanks NickC, your code was very close to produced the output I was hoping but I got incomplete combinations. Also, would it be possible to have output combinations parsed in three different columns?

Grouping
1 A D
1 B D
1 C D
2 J N
2 J O
2 K N
2 K O
2 L N
2 L O
2 M N
2 M O
2
2
2
2

Hi
I'm not sure what you mean by "incomplete combinations", can you give more detail or upload an example spreadsheet?

this version of the macro should put your data into adjacent columns

Please Login or Register  to view this content.