Ken,
Thanks, I have everything sorted but I am not sure what you mean by doing a max 6.
What I need at the end is:
Supplier 1, Item A etc
Supplier 1, Item A etc
Supplier 1, Item A etc
Supplier 1, Item A etc
Supplier 1, Item A etc
Supplier 1, Item A etc
Supplier 2, Item B etc
Supplier 2, Item...