Hi Experts,
I want to write a query to group the data by groupID.
GroupID GroupName MenuItemID MenuItemName
8 Cheese 25 Cheese Pizza (VEG)
8 Cheese 12 Bean & Cheese Quesadilla (GF & VEG)
8 Cheese 13 Bean & DF Cheese Quesadilla (GF, VEG, & V)
8 Cheese 26 Cheese Quesadilla (GF & VEG)
8 Cheese 28 Cheese Quesadilla w/ DF Cheese (GF, VEG, & V)
8 Cheese 27 Cheese Quesadilla (VEG)
8 Cheese 121 Vegetable Quesadilla (VEG)
8 Cheese 122 Vegetable Quesadilla w/ DF cheese (VEG & V)
18 Grilled Cheese 64 Grilled Cheese on GF Bread (GF & VEG)
18 Grilled Cheese 65 Grilled Cheese w/ DF Cheese (VEG & V)
18 Grilled Cheese 63 Grilled Cheese (VEG)
I want like this
Cheese
Cheese Pizza (VEG)
Bean & Cheese Quesadilla (GF & VEG)
...
...
Grilled Cheese
Grilled Cheese on GF Bread (GF & VEG)
Grilled Cheese w/ DF Cheese (VEG & V)
Thanks in advance.