multiple criteria match showing mixed results

I have a spreadsheet that I am trying to create using the Database functions, that I am apparantly not understanding. There is a lot of raw data that I need to combine into "labels" (like mailing labels, not used for that but same kind so if I can just get the data into a mail merge format I can make them in Word). The data is already sorted. I am trying to stay away from array formulas, but I am not married to the idea.
In column C-Performance
In Column D-Row
in Column E - Seat
In Column F -Section
In Column G - Guest name
The labels must show the Guest name on the top
then the SECTION, Row and Seat(s)
then the performance.
My biggest hang up is the guest name can be repeated (if the group is large they can/do sit at different tables, rows, sections. And there can be other guests in the middle -- guest one at A 11 seat A and guest two at A 11 Seat B-C and guest one at A 11 D-E-F)
How can I make Excel pull data based on 3 criteria and then show all the seats used in each label?
realizing this makes little (no) sense I have attached an example. Sorry to be so eclectic. (also sorry I didn't take this week for my vacation)

Re: multiple criteria match showing mixed results

I love pivot tables! It is my boss that is more difficult. Can I use a pivot table to print labels from though? I have tried about every combination of match and vlookup and AND and IF and DGET.... all I have so far is a headache. Going to take some aspirin and check out your example.
Thanks Dave, you're the best.

Re: multiple criteria match showing mixed results

Looking at the table...did I mention that I have to print up to a thousand labels a performance, 8 performances a week? the pivot table gives me the information I want, but I don't know how to use it in the format I need without selecting each page individually. Am I missing something?

Re: multiple criteria match showing mixed results

I need to take the data on the first sheet (changes daily, it comes from the reservation system just as it is except for the formula in the last column; that I am going to move to a different worksheet that is hidden so it isn't overwritten daily). The average day will be between 1000 and 1500 rows. (Matinee days will be double that.)
If the data is formatted like the second worksheet, I can do a mail merge to print the table labels.
What is throwing me is the seating. There aren't really any formula's on this example, I threw it together on the fly as I have two other spreadsheets due tomorrow that I am just starting, so sorry but I think you can better see where I am going with this.
Sorry also, it took so long to answer your post, I was too busy at work to check back, and have divided my time since between trying every function that MAY work and tossing pencils at my monitor.
Any help you can give will be greatly appreciated.
Thanks :?

Re: multiple criteria match showing mixed results

Thanks Dave, for trying. The data changed because I can't use real names, etc from my company online and I am at a different computer than previous posts so I had to create new examples. In my first post I was trying to show you where the data needed to end up - on mailing labels. I shouldn't have it confused the issue, I only need to get Excel to format it for use in a mail merge with Word and then I can get the mailing labels from there. Pivot Tables would be great if I was just collecting info, but I can't see how it could work for printing over a thousand labels at one time - in your example I could see the data I needed, but it only displayed one at a time and only showed one seat.
Thanks again for trying. If I figure this out..and I have to lol...I will post an example.
Thanks!