Hi Datafam ,
Attaching the image of input and desired output. Can someone please help me to generate the output. Attaching the input file for your reference.I want prices of all Main Course and desserts or what ever category in separate columns and also Total price as separate column for each individual. Thanks in Advance.

Regards,
Deepak