Group Data into Piles

how many groups, max size of group ?

Into 6 groups, in each group, not more than 2 from each category.

There are 13 items from the in each ty category

Wazeem said:

I have set of Data which contains 91 lines, I want to group them into 6 groups but I only want 2 items from the same category to go into each group. Can someone help me archive this?

Click to expand...

Wazeem said:

There are 13 items from the in each ty category

Click to expand...

If there are 13 items in each category and the maximum you can take from each category is 2, then 6 groups will handle 12 total items from any one category... what is supposed to happen to the 13th item in each category which cannot be fit into one of the 6 groups?

Pls snap screen

Well, what I'm trying to achieve is not more than 2 items from the same category in one group, it can have more than 6 group, in this example, it can have the 7th group.

team 1 team2 Team 3 team 4 team 5 team 6 team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14

team2 Team 3 team 4 team 5 team 6 team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14
Team 3 team 4 team 5 team 6 team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14
team 4 team 5 team 6 team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14
team 5 team 6 team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14
team 6 team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14
team 7 team 8 team 9 team 10 team 11 team 12 team 13 team 14
team 8 team 9 team 10 team 11 team 12 team 13 team 14
team 9 team 10 team 11 team 12 team 13 team 14
team 10 team 11 team 12 team 13 team 14
team 11 team 12 team 13 team 14
team 12 team 13 team 14
team 13 team 14
team 14

What you see above is all posible out come in a in a league which has 14 teams if they play each other, I want all this outcomes into 6 groups but on each group one team should only be playing twice..