Please help!! Formula crisis!!

[Wazeem]

Hi guys,

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?

Many thanks,

Wazza

 

[shg]

Duplicate post: https://www.mrexcel.com/forum/excel-questions/1044989-group-data-into-piles.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).