Form groups from list

[Noeleke]

Dear MrExcel members,

I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me.

I want to make groups of x amount of products from a list.

Example list:

1A34
2B43
1B544
5C45
3A52
5B32

Now I want Excel to automatically make groups containing 1xA, 2xB and 1xC, selected from top to bottom (because of priorities). Is there a way to cut those products out of the list, so I can see what products are still left to be grouped?

Thanks so much!