Altru Group Reservation Query- attendees by price type column instead of row

Meghan Dye

Is there a way to run a Group Reservation Query that would show each reservation as one row in the spreadsheet with the different price types in different columns? Right now if a Group Sales reservation has 3 different price types, it shows as 3 rows in the spreadsheet for 1 reservation. I can use the SUM function to make it add them all together and be one row but for some purposes we would want to see how many of each price type. I can provide examples of what it looks like now versus what I want it to look like if that is helpful.