Order values by category and mention the category name

[Filbius]

Hi all,

I would like to list values ordered by category and mention each category before listing all the items in it.  Something like:

FRUITS

apples

bananas

VEGETABLES

carrots

potatoes

MEAT

beef

chicken

Is there any way to do so?

To put some context, I built a CRM and would like to email transporters the list of places they have to pick up items from and the delivery places each item goes to. 

I am no coder, sorry if I am not using the correct terms or lack accuracy. 

Thanks in advance!

[Joseph_Seddik]

Hello Filbius and welcome to the community!

Please show us what you've built so far so that the community is better able to help you. 

[Filbius]

Ok, so basically I built a CRM, it works to track my orders. 

I would like to be able to send an email to my suppliers with:

- Where to pick up stuff (supplier's name)

- Where the order is going (client's name). Several destinations will be listed under, pretty much as displayed in the following screenshot: 

(The supplier names are Champagne Autreau, from which there are 3 client orders to pick), and Gallician Signature)